Search found 4 matches
Search found 4 matches • Page 1 of 1
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_...
- Fri Sep 16, 2016 8:28 am
- Forum: Vertica SQL
- Topic: Overlapping time intervals
- Replies: 2
- Views: 4795
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/...