This approach is with superstore data, where there are multiple order dates for a customer.
Let me know if it's close to what you're looking for.
P.S. If you don't need to show the different transactions and all you care about is the datediff then the logic is much easier.
This is the approach with the layout that you requested:
That looks great. One more thing...my goal is to find the average customer cycle time (time between purchases).
So the total sum of days is close, but can you take the average number of days between each purchase and come up with a table average?
Thanks a ton!
No problem, glad to help