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 in Tableau by Sanjana
62 views

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 by Cherukuri
• 32,260 points

reshown Aug 12 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 by anonymous
Hey! Register at Edureka Community and contribute(ask, answer or comment) and earn points and reputations.