6 Replies Latest reply on Jun 10, 2016 4:04 AM by Steve Taylor

    Display certain text when everything is deselected in filter

    John Mills

      Hello, I'm new to Tableau and am not sure how to do this. I have the following calculated field:

       

      IF COUNTD([Option]) > 1 THEN "Multiple Options Selected"

      ELSEIF COUNTD([Option]) = 1 THEN ATTR([Option])

      ELSE "No Option Selected"

      END

       

      The first two lines work, but when everything is deselected the entire field just goes blank instead of saying "No Option Selected". I've attached the workbook. Thanks for any help!