4 Replies Latest reply on Aug 17, 2018 8:09 AM by Celeste Williams

    Calculating the number of blank cells

    Celeste Williams

      I have a calculation that determines the percentage of past due records by counting those rows that have a value in a column titled "Days Past Due", and divides that by the total number of records. We have decided to use the opposite metric, calculating the percentage of records that are NOT past due. I am struggling to figure out the right way to do it.  The original calculation was: (count([Days Past Due]))/(COUNT([Status])).  I tried using (count(ISNULL([Days Past Due]))/(COUNT([Status]))), but that returned values of 100% for everything.

       

      I am on Tableau 2018.1. Any suggestions are appreciated!