Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k 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])

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. 

1 Answer

0 votes
by (47.2k points)

Use the below line to fix the problem:

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

Related questions

0 votes
1 answer
0 votes
1 answer
asked Aug 27, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...