Skip to main content

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.

Does this look about right?

Link to base

Does this look about right?

Link to base


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

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

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

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


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? 

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


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. 

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. 


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

Terms & ConditionsAccessibility statement