2 Replies Latest reply on Aug 23, 2016 12:12 PM by d Vermaak

    Displaying text on null or blank values?

    d Vermaak

      Hello all,

      I've built myself a nice dashboard tracks a monthly audit:


      Here's the problem that I'm running into though: there are some locations who may have only received 1 or 2 audits so far, so some of those KPI's (Current Month AVG, Prior Month Difference, etc) will be blank because the data isn't available:



      This is an example of a location that has only received 1 audit. As you can see, several of the fields are blank because there isn't enough data to look at prior month's/quarters.

      What I'd like to do is have the blank fields show some placeholder text like "Audit Not Available" or "Test Data Not Available" or something like, doesn't really matter tbh.
      How would I do this?