Skip to main content

Avg. sales by date, problem with timeframes

  • April 23, 2024
  • 6 replies
  • 44 views
J
Forum|alt.badge.img+2

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.

6 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Does this look about right?

Link to base

Adam, Airtable Consultant - thetimesaving.company
J
Forum|alt.badge.img+2
  • Jakub
  • Author
  • New Participant
  • April 23, 2024

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
TheTimeSavingCo
Forum|alt.badge.img+31

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

Adam, Airtable Consultant - thetimesaving.company
J
Forum|alt.badge.img+2
  • Jakub
  • Author
  • New Participant
  • April 24, 2024

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? 

J
Forum|alt.badge.img+2
  • Jakub
  • Author
  • New Participant
  • April 24, 2024

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. 

1 Attachments
TheTimeSavingCo
Forum|alt.badge.img+31

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

Adam, Airtable Consultant - thetimesaving.company
Terms & ConditionsAccessibility statement