I want the calculate the Completed percentage in the below data

Question

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%

Answer 1

Hi Sanjana,
Try creating a calculated field as below.
SUM(IF [Status] == "Completed" THEN 1 ELSE 0 END)*100/SUM({COUNT([Deliverable])})

Answer 2

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%

Comments

Hey! Register at Edureka Community and contribute(ask, answer or comment) and earn points and reputations.