We are managing all our orders in Airtable and I’m trying to calculate the time between orders to get an average for each customer.
So a client orders, say on September 13, and then the same client orders again September 19 and September 25. I’ve been trying to figure out a solution, but have a hard time.
How can I calculate the datetime_diff between records in the same table?
Thanks a lot!