0 Replies Latest reply on Nov 23, 2018 8:59 AM by John Burton

    Calculated field that equals zero when all rows are filtered

    John Burton

      Hi,

       

      I'm trying to create an aggregate calculated field that counts the distinct members in a dimension field and when there are no IDs equals zero.  For example, in the attached, with no filtering on any of the dimensions countd() equals 11.  I want to make a descriptive label in a dashboard so I've added some text to say "11 distinct IDs".  Everything works fine, except when all rows are filtered out.  In this case I want the label to say "0 distinct IDs".

       

      I've tried a few ways but can't figure out how to get what I want.

       

      Does anyone know the answer?

       

      Thanks!

       

      John