Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I'm having some issues calculating customers with repeat purchases.
I have a table similar to this:
Week | CustomerId | OrderId |
5 | 200 | 1000 |
5 | 300 | 2000 |
6 | 400 | 3000 |
6 | 200 | 4000 |
7 | 300 | 5000 |
7 | 200 | 6000 |
How would I do to get a value of how many repeat customer purchases there are in week 7 for example? As you can see, CustomerId 200 and 300 are both recurring, so the value I'm looking for for week 7 would be "2" repeat customers.
I was thinking Set Analysis but can't get it to work, anyone have any ideas?
Best
/P
May be like this
Count(DISTINCT {<Week = {'$(=Max(Week))'}, CustomerId = p({<Week = {"$(='<' & Max(Week))"}>} CustomerId)>} CustomerId)
May be use
Count(CustomerId)
Hi,
Sorry if I was unclear, but when selected only week 7 I would like to count if there is any previous orders by each customer
May be like this
Count(DISTINCT {<Week = {'$(=Max(Week))'}, CustomerId = p({<Week = {"$(='<' & Max(Week))"}>} CustomerId)>} CustomerId)
Based on selection in Week 6, I am getting only 1 repeat customer
hi,
how do you use the same formula to check how many repeats called in 24 hours, 48hours and 72 hours?
Do you know a way to do the same thing for consecutive giving years to find the retention rate for donors?