I have KPIs and charts that are placed at the Account level where there is no value present how can we display the values as zero in the KPIs and charts (corresponding to a month where there is no value present). How to display it as zero? Currently, it is displayed in the attached screenshot
Hello @Shivangi Tiwari,
For KPIs it's pretty straight forward. All you have to do is to click on your KPI and go to the properties (on the right);
- check the option " Customize message for no results "
- Replace "No Resultls Found" by 0 on the Message field that appears just there at the bottom
On charts we do not have this option, but I encourage you to make use of the function "coalesce", that sometimes will help avoiding your calculations defaluting to nul in case of a missing value.
