Hi everyone!
I created a metrics table to count how many "Critical, Major, Lesser" observations I have per a CRO Management group for a specific timeframe (quarterly).
The formula I used in the metrics sheet is as follows:
=SUM(COLLECT({Audit Schedule Range 6}, {Audit Schedule Range 2}, "CRO Blood and Marrow Transplant", {Audit Schedule Range 3}, "Complete", {Audit Schedule Range 1}, OR(@cell = "7-2025", @cell = "8-2025", @cell = "9-2025")))
I completed this for all management group and the sheet populated the counts correctly.
Going into the dashboard, I chose the metric sheet and highlighted the relevant data, only to receive this error code:
Couldn't save - Error: Validating Request - Updating the datasource field for a widget with a data source of ANALYZE_DATA is not allowed for widget with id: 1066143396
I am unsure how to fix it because I used the same sort of formulas to create another metrics sheet and dashboard chart with no issues.
Any guidance would be appreciated!
Warm regards,
Nayana J.
