Avg. sales by date, problem with timeframes

[Jakub]

Hello, I find it difficult to work with time frames in Airtable. Am I missing something?

Example:
Let's say I'm selling cars and with each sale I add it as a sold car record to Airtable with its details.

Manufacturer: Audi
Type: A6
Date: 22/3/2024
Price: 50 000 €
Condition: New

Now I have a DB of all cars sold in last 4 years and I would like to make an interface where I would filter variables (type of car, condition, ...) and timeframe it was sold in to see my average monthly sales of cars that corresponds with my filter. 

So basically I would know that based on data from last 24 months, I've sold avg. of 0.8 Audi A6 per month.

Any ideas? Thanks.

[TheTimeSavingCo]

Does this look about right?

Link to base

[Jakub]

Unfortunately, I'm unable to open the link.

This site can’t be reached

Check if there is a typo in avg.%20sales%20by%20date,%20problem%20with%20timeframes.

DNS_PROBE_FINISHED_NXDOMAIN

[TheTimeSavingCo]

Ah, sorry about that, I've fixed the link in my previous post

[Jakub]

Thank you for your reaction.

Basically yes. That would work for me.

But how to switch my list of cars to the "Date" list with SUMS of specific records of my choice? 

[Jakub]

You see, I'm able to filter how many machines I have sold in total, but I don't know how to make an "Avg. monthly sales" field that would divide the total sales by the number of months that passed by. 

[TheTimeSavingCo]

re: But how to switch my list of cars to the "Date" list with SUMS of specific records of my choice?

Hm, sorry, I don't understand the question.  Could you rephrase it please?

---
re: You see, I'm able to filter how many machines I have sold in total, but I don't know how to make an "Avg. monthly sales" field that would divide the total sales by the number of months that passed by. 

Yeah, we're going to need a table where each record represents a single month's sales for a single car, and the Interface would display the data from that table