Count field based on condition in other field

Question

I am trying to create a Tableau calculated field. Can someone help me rewrite the following code so that it uses the correct syntax?

COUNT([Type of Event]

IF(CONTAINS([Name of Event], "CANCELLED") = false) 

THEN 1 END)

 

Answer 1

Try this calculated field:

COUNT( IF not CONTAINS([Name of Event], "CANCELLED") then [Type of Event]   END )

Check out this Tableau Tutorial for more reference and information or get indepth knowledge about this field through Tableau Certification Course by Intellipaat.

You can also have a look at the below video to start with Tableau training.