Forum Discussion
Solved
Customer segmentation using DATESINPERIOD
Good morning everyone, I'm trying to segment customers over time so that I can see, for any given date (point in time), how many customers had purchased only once in the previous 4 weeks, how man...
Hey,
I gave it a try and that's the solution that worked for me. You will see that I used DatesBetween instead of DatesinPeriod. But I'm sure that it may work in both ways.
Below the results I got.
Hope it helps.
Hey,
I gave it a try and that's the solution that worked for me. You will see that I used DatesBetween instead of DatesinPeriod. But I'm sure that it may work in both ways.
Below the results I got.
Hope it helps.
Hey Anonymous , that's perfect, thanks a lot 🙂 I'm not sure why what I had done didn't work, I'll have a think about that one!