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


      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!