1 Reply Latest reply on Jan 2, 2019 4:31 AM by Alejandro Moreno

    Calculated field that equals zero when all rows are filtered

    John Burton



      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?