I want the calculate the Completed percentage in the below data

+3 votes

If my data is like this :

Deliverable Status
Task 1 Completed
Task 2 Completed
Task 3 Completed
Task 4 InProgress
Task 5 InProgress


I want to calculate the percentage of 'Completed' Status.  And the output should look like below in Tableau : 
Completed: 60%
Aug 12, 2019 in Tableau by Sanjana

2 answers to this question.

+3 votes
Hi Sanjana,
Try creating a calculated field as below.
SUM(IF [Status] == "Completed" THEN 1 ELSE 0 END)*100/SUM({COUNT([Deliverable])})
answered Aug 12, 2019 by Cherukuri
• 32,930 points

reshown Aug 12, 2019 by Cherukuri
+2 votes
first drag status field in row shelf and then drag number of records text under mark card. after draging number of records field right click on number of records field and go to quick table calculation then select percentage of total....

completed : 60%

InProgress : 40%
answered Nov 2, 2019 by anonymous
Hey! Register at Edureka Community and contribute(ask, answer or comment) and earn points and reputations.