How to represent ZERO on a Gauge Chart KPI?
For executive reporting we would like to show KPI # values on Dashboards using a Gauge Chart to represent # of review items completed and another KPI to show review items left to complete.
In this use case there are many times when the Gauge Report should report a zero.
Example: # of review items left to complete should be zero if all reviews are complete
Example: Both Review Items Completed and Review Items left to complete would be zero if there are No Review Items on the Agenda to Review.
We are using filters to identify the data set.
How do we get the Gauge Chart to represent zero? In the examples above we get a message "There aren't any matches for this report filter". Perhaps we should be using a report formula in addition to a filter?
------------------------------
Annetta Coleman
------------------------------