6 Replies Latest reply on May 8, 2018 3:29 AM by Fernando Kommers

    How to display 0 instead of null when no data (dates chart)?

    Fernando Kommers

      Hi,

       

      I need to create a chart where I show a timeline (per Quarter) of when certain people have met certain criteria. My data looks like the table below, one student per line:

       

      Student NameCertification NameCertification StatusDate of Certification
      ABasicApproved04/20/2017
      BBasicApproved08/12/2017
      CBasicApproved01/30/2018
      DBasicPending-
      EBasicApproved06/04/2017
      FBasicApproved09/21/2017

       

      My calculations are this:

       

      Column: IF [Certification Status] = "Approved" THEN ([Certification Date]) ELSE NULL END

      Row: IF [Certification Status] = "Approved" THEN 1 ELSE 0 END

       

      Utilizing the "Show missing values" option, this is the table I've got so far:

       

      2017 Q22017 Q32017 Q42018 Q1
      221

       

       

      What should I do to show a "0" for "2017 Q4"?

       

      Thanks!