This Lookml project is based on the 8 Period Over Period Analysis Methods published on Looker Help Center: https://help.looker.com/hc/en-us/articles/360050104194-Methods-for-Period-Over-Period-PoP-Analysis-in-Looker

Currently this project contains PoP for Redshift, Snowflake, Bigquery and MySQL. More dialects might be added in the future.

Similar to how you get the code from the Looker help center, you can directly copy and paste the code in your Lookml project, they you can replace the SQL field based on your table. Since the code has been adapted based on each dialect, customizing the SQL syntax would be optional.

Method 1 - Method 7 for all project are working, Method 8 for Snowflake and MySQL still needs more improvement

This project is open source, if you encounter any issues or want to share any feedback about this project, please raise an issue in this repo. Looker support team is not responsible for maintaining and supporting this repo.

Contributors:

• Won
• Flavia
• Kento
• Xin