CODEWITHSUNDEEP
tableau-api
Anna Huang
Anna Huang

Reputation: 297

Tableau Conditional Count Distinct

This is a snapshot of the data pulled into Tableau: enter image description here

Success Count is defined as if [Task Status Cal]="Success" then [Wo_ID]

The formula for [Success Count] was:

IF [Task Status Cal] = "Success" then STR([Wo Id])
end

Tableau considered this formula to be valid.

I am not sure why the result was null in cases where the above condition was true.

Thank you!

Upvotes: 3

Views: 8822

Answers (1)

Daniel Honigsblum
Daniel Honigsblum

Reputation: 88

Do the next: countd(IF [Task Status Cal] = "Success" THEN [Wo Id] END) it should fix the problem :)

Upvotes: 5

Related Questions