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:
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.
Code: Select all
select date, (count(status like "Complete")/count(status)*100) from table group by date;