
1. Re: How can I calculate the difference in dates along a single column of dates?
Aaron Clancy Feb 6, 2014 3:18 PM (in response to Austin Barry)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.
Customer Datediff
A 3
B 25
C 15
D 22
This is the approach with the layout that you requested:
Calc:
Compute Using:

2. Re: How can I calculate the difference in dates along a single column of dates?
Austin Barry Feb 7, 2014 8:04 AM (in response to Aaron Clancy)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!

4. Re: How can I calculate the difference in dates along a single column of dates?
Austin Barry Feb 7, 2014 12:28 PM (in response to Aaron Clancy)Thanks a ton!

5. Re: How can I calculate the difference in dates along a single column of dates?
Aaron Clancy Feb 7, 2014 12:30 PM (in response to Austin Barry)No problem, glad to help