I have a report page with a bunch of scorecard controls on it that hasn't been working right for the past month or so.
It shows a summary of the accomplishments of the many "Adopt-A-Shoreline" trash cleanup volunteer groups we have. We track the number of cleanups, # of volunteers, bags collected, tires, and propane cylinders for each group, which it reads from a tab in a large Google sheet.
The scorecards on the top row of the page show these stats for all our AAS groups for all time. These work.
On the lines below we show the same stats for the current year, adding a filter on the date. These do not work, showing a wrench symbol with a detail message of "Data set configuration error. Looker Studio cannot connect to your data set. The underlying data has changed. Please notify the data source owner to refresh." If I remove the date filter the error disappears.
I've tried the following without success:
- Refreshing the data source
- Removing and readding the data source
- Changing the comparisons in the date filter
- Removing the date filter and instead setting a date range for the scorecard
- Looked for bad dates in the date column of the data source.
The format of the data sheet has not changed in years, to my knowledge.
Any thoughts on what I can check next?
Thanks, Carl
To
LinkedIn
Twitter
