I want the calculate the Completed percentage in the below data

+2 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 in Tableau by Sanjana

1 answer to this question.

+2 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 by Cherukuri
• 27,960 points

reshown Aug 12 by Cherukuri