4 Replies Latest reply on Aug 14, 2016 4:23 AM by siyang.teo

    Calculated Field Query: If else statement based on aggregated values of another column

    siyang.teo

      Hi, I am trying to create a calculated field in Tableau using the example below.

       

      Red is the desired output. It should give a "Y" for types of Species, e.g., Cat, when just one or more contains a Disease marked by "0".

       

      Can anyone help? I am still pretty new to Tableau. Thanks!

       

      Capture.PNG