I'm working off of a spreadsheet that has a list of Activity ID's and whether or not they have their ROI Complete, which is a Yes/No. Here is an example:
If I do a quick calculation using a Count Distinct of the Activity ID, I can see that 62% of Activities have ROI and 38% do not.
I am able to display the data in Tableau in a table like this:
But ultimately I am trying to build a Dashboard that shows a snapshot, which only includes the Yes Percentage. So in the Dashboard, I want that section to say:
ROI Complete: 62%
I am not sure how to show the percentage for the Yes value only without removing the No and messing up the calculation.
I'm using version 8.14.
Really appreciate your help!
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...