Hello Looker community!
At Montreal Analytics, almost all our Looker projects were at some point in need of period over period analysis.
While there are a lot of blocks & patterns available out there, we tasked ourselves to build our own based on our experience.
The goal here is to achieve that kind of experience:
Our approach is not as flexible as other you could find (you can compare one period - current or in the past - with the previous one only), but we found out that it was enough for 80% of our use case which is good enough for a block 🙂.
We actually published the tutorial in a 3-parts blog post that you can find here:
- Part 1 - Build the 2 parameters and 2 dimensions to get started on PoP
- Part 2 - Improve on the model and experience
- Part 3 - Advanced modeling with Liquid
Hopefully, you’ll find value there.
Let us know what you think!