Formula that Calculates average order history

[RKCrizzle]

Hello All,

I am looking for a formula that will calculate historical orders placed with the option to query 14, 30, 60, 90 and all time order history. Is there a way to do this? I am very new, go easy on me :slightly_smiling_face:

[Mohamed_Swella1]

Hi again @RKCrizzle, :slightly_smiling_face:

If you are on the Pro Plan, you can use the Blocks feature to do charts where you can group them by Week, Month, Quarter, or Year.

If you are on the Free Plan, there can be some work arounds.

BR,
Mo

[RKCrizzle]

I don’t have the pro plan (yet) I’m trying to teach myself (with your help) Airtable before deciding to invest. Ideally id have a list of products and then a field that allows me to choose how that specific products purchase history is referenced.

for instance, for milk products (which expire in 2 weeks) I only want to see purchase history for the past 2 weeks. Alternatively paper towels which don’t expire id like to reference for a longer history.