Our problem is the following; we are collecting information about customers visiting our page. We are intrested in counting repeated visits by the same customer in a specific time range - we would like to determine the number of customers that visited the page once, twice, three times, etc.
We approached the problem by creating "customer-centric index", counting visits by each customer (total visits), time of first visit and time of last visit.
What we are missing with this solution is the possibility to filter the visits in a specific time range.
For example: If a cusotmer visited our page 2-times last month and 3-times this month, the total number of visits is 5 (which we are able to count), but we are not able to get information only for a specitic time range, for example visits in last month, where the answer would be 3-times.
We would like to present our data the following way (data not related to the above example):
Any help appreciated.