I have a dashboard created that displays sample location points and their associated data. All of the data is located within a single table that is referenced to create graphs depicting both historical data and annual averages. Of the 5 sample locations, i can view historical data for all of them and yet only view the annual averages on 3 of the 5 locations. For 2 of them I get hit with a data access error. Which is weird considering its pulling all data for all 5 locations from a single table. When i go into the editor and settings for the annual averages graph, the preview graph actually shows all 5 locations data. Which is odd since when i leave the settings, it still will not display 2 of the locations' data.
So it seems that the dashboard is capable of pulling and displaying all the data within the graph preview in the editor, but is not able to show some of the data (but not all) in the actual dashboard. Any thoughts?