Issue overview: In June 2024, Looker Studio introduced an update focused on validating aggregations in widgets. Unfortunately, this update led to an issue where widgets containing the dimension "Date" incorrectly display a warning sign with the message "Data quality (Data aggregation issue)." We want to reassure you that despite this error message, the data retrieved from Funnel is aggregated correctly. Our solution: To address this issue, we have implemented an update in how Funnel shares schemas with Looker Studio. This update ensures that your data continues to display accurately and without errors.
Quick fix guide:
We have created a step-by-step guide to help you resolve this issue quickly. Below is a summary of the steps you need to follow. For those who prefer a visual walkthrough, a detailed video is also available.
Go to the affected Export in Funnel
Click Edit and Choose fields
Remove the Date dimension and click “Use these fields”
Save and confirm the field removal from the Export
In Looker Studio, go to the Funnel data source and “Refresh fields”.
Confirm the removal of the Date dimension
Go back into Funnel, add back the Date dimension to the Export, and “Save”
Go back into Looker Studio and “Refresh fields”. Apply that Date has been re-added as a new field
Refresh your Looker Studio report, and the error message should disappear
Video walkthrough: