0 votes
1 view
in BI by (17.1k points)

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])


Tableau considered this formula to be valid.

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

1 Answer

0 votes
by (46.1k points)

Use the below line to fix the problem:

 countd(IF [Task Status Cal] = "Success" THEN [Wo Id] END)

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !