CODEWITHSUNDEEP
filtertableau-apicalculationdividecalculated-field
J A
J A

Reputation: 45

How to divide the count of 2 different values within the same 1 column in Tableau?

enter image description here enter image description here enter image description here

I am trying to divide the data above, that is in the same column within my raw data. The one column name is "Status". I split it under this column into 2 separate columns within Tableau.

How would I create a calculation to divide T & D by each other? For an example, I would like to divide 166/1523, 155/1535, etc.

How do I differentiate between these 2 under the same column "Status".

Upvotes: 0

Views: 1027

Answers (1)

Sound in Worship
Sound in Worship

Reputation: 478

SUM (IF [Status] = "T" THEN [Your Measure] END)
/
SUM (IF [Status] = "D" THEN [Your Measure] END)

Upvotes: 2

Related Questions