Tableau - Similar function to SQL Group by

General discussion forum about all databases other than SqlBase.
Posts: 1
Joined: 28 Dec 2017, 11:35
Location: Hyderabad, India

Tableau - Similar function to SQL Group by

Post by AlexaCaroline » 28 Dec 2017, 11:44

I have recently started using Tableau but am still very new to it. I don't know enough about the Tableau vocabulary to be able to find this answer through brute force googling. Hopefully, some one here can help point me in a good direction.

I have a simple table of data, containing the columns and types: Date (Date), ID (Numerical), and Status (Text)

I want to be able to generate a report that has: Date, and Percent of the IDs on that date where the Status is "Complete."

In SQL I could do this by running a query along the lines of:

Code: Select all

select date, (count(status like "Complete")/count(status)*100) from table
group by date;
Where can I look for this in Tableau? I tried creating a new Calculated measure on the sheet I am working on, but I couldn't find any built-in functions that would add this ability. Thanks for any assistance.

Thank You

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests