Stuck doing this in Magic ETL:
Trying to calculate the average time between orders. For each record in the DataSet, add a field showing the number of days since the previous order for that customer.
Customers have multiple orders so I can't use Max(date)