Checking Totals in an explore raise an error when POP measure is being used in the explore

Looker Q&A Looker
, ,
1

Hi

I was trying to implement the new POP feature and it works nice ly when

1 - you use a date dimension, if you dont youll get many rows in the result and not one as expected

2 - you dont check Totals in the explore,if you do check the Totals checkbox then youll get an error

please see attached pic showing the error and the query

Explore_Business_Overview__POC_
Explore_Business_Overview__POC_2252×729 291 KB

Drive Decisions Faster: The New Era of Period-Over-Period Analysis in Looker
2

same error here, got any solution?

3

Im afraid this is by design due to limitation of how its built

4

Hey,

Hope you’re keeping well.

The POP (Period-over-Period) feature in Looker relies on a date dimension context to calculate shifts, so without a date dimension the aggregation logic can produce unexpected row expansions. Totals queries are run separately from the main query, and currently POP measures are not fully supported in Totals because the SQL generated for the POP calculation often cannot be applied cleanly to the totals subquery. To avoid the error, keep a date dimension in the explore when using POP and disable Totals, or create a separate measure that replicates the POP logic but works on an aggregated dataset for Totals. If this is critical for your workflow, I’d recommend logging it with Looker support via the Looker Help menu so they can confirm whether it’s a known limitation or a bug in your version.

Thanks and regards,
Taz

5

Hi there - Thanks for the feedback. This is a current limitation with PoP measures, however support for Totals is being worked on and will be addressed in a coming release.

Aleks