Apr 23, 2024 05:02 AM
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.
Apr 23, 2024 05:22 AM - edited Apr 23, 2024 07:16 AM
Apr 23, 2024 05:50 AM
Unfortunately, I'm unable to open the link.
Check if there is a typo in avg.%20sales%20by%20date,%20problem%20with%20timeframes.
Apr 23, 2024 07:16 AM
Ah, sorry about that, I've fixed the link in my previous post
Apr 24, 2024 05:10 AM
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?
Apr 24, 2024 05:18 AM
Apr 24, 2024 08:12 PM
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