Unable to display column chart and metric widget not showing value.

Hello Everyone,

Column chart issue:

I am encountering errors while attempting to display the column chart on the dashboard. The error message states, "Unable to display chart." The data source of the column chart is one report, and source sheet(Formula sheet) of this report is getting reference from another sheet. In the source sheet, I am using the cross-sheet formula to get the data from other sheets.

To solve this issue, I have to open the sheet and then save the sheet. Then I refresh the dashboard, then I am able to see the chart.


Metric widget issue:

I am using the metric widget in the dashboard to get the value. The data source for this metric widget is a sheet summary. When I open the dashboard so sometime, I am getting an error that time value is not shown.

To solve this issue, I have to open the sheet and then save the sheet. Then I refresh the dashboard, so I can see the chart.

Thanks in advance.

Answers