If I export the exact same table with the exact same dimensions and metrics, I get two different metric numbers for the same month depending on whether I export just that month versus exporting the full year including that month.
Why would that be?
Hey,
Hope you’re keeping well.
This is likely due to how Looker applies filters and aggregation at query time. When you export only a single month, the query is scoped to that month before aggregation, but when you export the full year, Looker aggregates at the year level first and then splits by month, which can change results if there are session boundaries or user counts that span periods. Check the Explore’s filter logic and whether you’re using table calculations or custom measures that depend on row context. You can confirm by reviewing the SQL generated for each export in the SQL tab to see how the WHERE clauses and GROUP BY differ.
Thanks and regards,
Taz