Months since first order


#1

Hello,

We currently have a spreadsheet that tracks sales to customers by month. Each row is a customer and each column is a month. This allows us to see total sales to each customer. We also can see average sales per month. (Total sales divided by numbers of months since their first order.) Any advice for building this out in an Airtable?

Ninja edit: It seems like the DATETIME_DIFF function might help. Still working on this.

Thanks,
–Victor


#2

You have to set up a sales table linked to a separate customer table. In customer table you can define a rollup field for sales date field o,f sales table, defining minimum as the option to roll up, and another rollup field for sum of sales amount. To compute the time from the first order define a column as a formula field that calculates the difference from minimum date field to today()