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:
Hopefully, you’ll find value there.
Let us know what you think!