Hi, I have found this article which helps with period on period comparisons however it is in big query and I work in Postgres. I have tried to convert it to post fees SQL but am getting errors. Has anyone previously managed to get it working with Postgres or could help? Thanks you!
https://community.looker.com/technical-tips-tricks-1021/methods-for-period-over-period-pop-analysis-...