I am currently handling a dataset where we get daily data per person. After creating my report and filtering by one day the data is displayed correctly, but as soon as I try to filter by multiple days the resulting sum is extremely large.
Example data:
Name | Hours Worked
John | 8
Chris | 12
Total daily average hours are 1000, while working 30 days a month gives us 30k hours. When I filter by the last month I end up with it displaying close to 550k hours instead of the expected 30k. This happens to my blended data, but not the raw data.
This issue is caused by re-aggregation and grain mismatch in Looker Studio’s blended data.
When the report is filtered to a single day, the totals are correct. However, when filtering across multiple days (e.g., last 30 days), the total hours become significantly inflated. This issue occurs only in blended data sources, while the raw (non-blended) data behaves as expected.
try to only include dimensions strictly required for the join. Additional dimensions increase the risk of duplication.
Thank you so much. That resolved the issue, now the numbers appear reasonable based on experience. Guess I have to make another blend to use other data I was including in the original blend.