2 Replies Latest reply on Nov 13, 2012 1:12 PM by Troy Forster

    Counting distinct ids where another column is not NULL

    Troy Forster

      Hi,

       

      I'm trying to create a calculated field that counts the number of distinct Ids in a table column based on the value in another column, but I need to do it at the Tableau level because I want to keep a third column's date i.e.

       

      Stuff          Id          Things

      A               1               X

      B               1               Y

      B               1               Z

      C               2               X

      NULL          3               X

      NULL          3               Y

      NULL          3               Z

       

      I want this to return the number of distinct Ids where Stuff is NULL (should return 1)

       

      Any thoughts?