I've built numerous dashboards and have never encountered this error previously.
i have a formula:
=AVG(COLLECT({Material Requests (Draft) Range 10}, {Material Requests Range 1}, "1", {Material Requests Range 2}, "2024", {Material Requests (Draft) Range 3}, "Central"))
This results a figure (0.39) and when I go to chart that data into a dashboard and select that cell (among other cells) in a Line graph the chart is created and contains an X and Y axis but no data is displayed. The ONLY way I can get the data to display is by going to my summary sheet with all of the AVG and SUM values that feeds the dashboard and click "save". Once that's done if I bounce back to the Dashboard it shows my data in the chart.
WHYYYYYY? Please help :-(