[Public Preview] Period over Period Measure

Period-over-period (PoP) analysis – whether you’re looking at year-over-year, quarter-over-quarter, or month-over-month trends – is the bedrock of strategic decision-making. But in Looker doing PoP analysis has previously required the use of complex workarounds using LookML.

We’re excited to share that a new, streamlined approach to period-over-period analysis is here, and it’s designed to cut through the complexity and empower you with clear, actionable insights faster than ever before. The new period_over_period measure type in Looker is available now in Preview!

Check out this blog post to learn more or visit our documentation page!

2 Likes

Genuinely so happy about this. PoP has always been a bit of a PITA, glad the team tackled that :slightly_smiling_face:

3 Likes

In the tests I performed, I noticed that the comparison will always be with the previous full period…and not proportional, did anyone get it differently?

This is the intended behavior through 25.8 and is something that is on our radar. Thank you trying out the new measure and the feedback!