This content has been marked as final. Show 2 replies
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?