Group A& C using grouping option in Tableau - Check this link how to group your data
Step 1: Drag Status to Rows now you can see completed, Yet to start and In Progress
Step 2: Create a calculated field like below
sum(measure value)/total(sum(measure value))
now you can see status wise % compared total value
My dimension values are string based such as A, B, C , D
The formula provided is for measures.
How do we count/ perform percentages for dimensions?
I didn't understand the question perfectly
> Do you want to see what is the proportion of status A in whole data set ?
If that the case use the NUMBER OF RECORDS in the place of measure values in above formula
If not could you please attach sample screenshot how you need the Ouput
You can create a calculated measure as:
count(if status='completed' then tasks end)/count(tasks) * 100
I created sample Data Set as below
Step 1: Group the Task A and B
Step 2 : drag Number of records to Text and select the % of Total
Step 3: You can find the 50% for completed
this is one way achieving the result
Hope this helps kindly mark this answer as helpful and correct so that it will help others