Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I have 2 columns (date, customer_id) and i need calculation table with count of distinct customer_id during last 12 month for every date.
For example
Date | Number of customers |
08.03.2017 | 3456 |
… | |
10.02.2018 | 6590 |
where 3456 -number of unique customer_id between 08.03.2017 and 08.03.2016
or 6590 - number of unique customer_id between 10.02.2018 and 10.02.2017.
I used solution like this, but it only works with the date that i set in the filter
Can you explain the date intervals? I don't know of any definition of 12 months that matches the interval between 08.06.2016 and 08.03.2017. Why isn't the interval 08.06.2016 to 08.06.2017?
Sorry. This is mistake. Post updated