This was the more performant method for PostGreSQL, where you cross join your active user table to a derived date table. I also checked it against the other method and my results matched one-to-one. ######### 1. DERIVED TABLE #########view: dates { d...

Completed this for PostGreSql and also included a Quarterly Active Users.Hope this helps someone, like all these folks above helped me. PS: I added a limit of 730 days, as I found this query took a long time to run compared to the other method. Also ...