This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a database with all the transactions of a set of customers. One important parameter for us is to understand each client's interval between two consecutive visits. In out database, each row is one visit as in the example below:
- For client 1, the interval between his 1st and 2nd visits were 5 days and between his 2nd and 3rd visits 10 days.
- For client 2, with only two visits, the interval was 20 days
Given that the number of visits can go up to hundreds, does anybody know how could I have another column calculating the number of days since the last visit?