Invalid Query for no apparent reason. Only works on certain dates.
I have created a dashboard for my two Facebook pages in Data Studio. In my dashboard I have a scorecard showing IMPRESSIONS and one displaying TOTAL REACH. When set to show data for the month of October they're both displayed correctly.
If I change to any other date all scorcecards and graphs related to IMPRESSIONS are displayed correctly, but my scorecard showing TOTAL REACH doesn't display and shows the following error message:
"Invalid query: running the query would require summing metrics with unique counts. Try splitting by month or week."(Supermetrics request ID: O4lVYpm376m9J5zjTwUC1fEO5Mv9w3D2).
What could be wrong?