How many customers where active last 365 days? We use this as a "churn" KPI. Say 3,456,466 customers made at least one purchase between yesterday - 365 and yesterday. Now we run the following query every day just to see for one day at a time or populate a spreadsheet: SELECT COUNT(DISTINCT CUSTOMER_...

Thanks Sharon, problem solved!

I have a login log from which I want to derive the first time a user logged in through a month plus n days. For a single period this is of course very easy, but I want an otput like: User-ID, Period Start, Period End, Min Log in time 1, 1/1/2016,2/10/2016,1/12/2016 03:24:12 1,2/1/2016,3/10/2016,2/5/...