7 Replies Latest reply on Nov 4, 2018 3:02 PM by Arnie Cohen

    How do I get Tableau to display a 0 in the last column of a table?

    Arnie Cohen

      I am already using a ZN function to count the occurrence of a "case".

      If there are no cases, then the null is converted to a 0 and it is displayed in my table.

      With the exception that if there is a null value (which I am converting to "0") in the last column (months) of my table (or a chart), then nothing is displayed.

      If I pad the data so the current last column is the second to last, a "0" shows up.

       

      this is the calculated field I am using. Again, as long as the data is NOT the last column, a 0 is displayed.

      If it is the last column, then nothing.

       

      ZN(COUNT([Case ]))

       

      Please help!!!

       

      thanks

      Arnie