Graphs with nil data return errors in Dashboard - Solutions?
I've set up a Document Suite that contains a number of Dashboards/Reports/Register that is deployed to our users when a new Project commences. Some of the Dashboards contains Graph widgets that are sourced from other sheets. As the source sheets are empty at project conception, the graphs typically return errors. To overcome this, I pre-populate some of the source sheets with low value numbers to elimiate the error. This seems counter-intuitive and against good reporting principles. As an example, the dummy data ends up in the dashboard looking like this;
But if I remove the values ($1 / $0.10c etc) from the source sheet it looks like this;
The source data hasn't been changed, it is just zero dollars. The source data is a helper sheet that looks like this;
Can anyone suggest any way that I can have the Dashboard Widgets return Zero Dollars or blank results in lieu of the Error Icon? Do I need to insert a IFERROR before my SUMIFS function?
I would rather deploy the workspace knowing that the Dashboards are free of abnormalities like the above and present in a professional manner.
Thanks for you help,