Hi Everyone,
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:
| Activity ID | ROI Complete? |
| 168037 | Yes |
| 168146 | Yes |
| 171930 | Yes |
| 168542 | Yes |
| 173127 | Yes |
| 164425 | Yes |
| 168042 | Yes |
| 172939 | Yes |
| 178236 | No |
| 170332 | No |
| 170233 | No |
| 170235 | No |
| 170334 | No |
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!
