What would be the average time between orders (TBOs) in weeks
Answers
Answered by
0
Explanation:
I've searched all over but cant seem to find how to calculate the average time between orders for each customer. I'm using Oracle SQL Developer. Ive tried using the lag() function with no joy.
Example data below shows a customer bought on 3 separate occasions. The average time between all purchases is 7.5 days ((6+9)/2).
Similar questions
Environmental Sciences,
8 days ago
Math,
8 days ago
Accountancy,
17 days ago
Math,
17 days ago
Physics,
9 months ago
Computer Science,
9 months ago