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;
Thank You
AlexaCaroline