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: AudiType: A6Date: 22/3/2024Price: 5...
Hello,I have this simple problem with filtering by date. When I try to filter Date - is within - past year I also got records from this year.Also If I try to filter Date - is within - past month I got only some of the records from the previous month....
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.
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?
Unfortunately, I'm unable to open the link.This site can’t be reachedCheck if there is a typo in avg.%20sales%20by%20date,%20problem%20with%20timeframes.DNS_PROBE_FINISHED_NXDOMAIN
Thank you. TBH, I'm pretty constrained by need of making those extra formulas in order to proceed with such basic operation, but your recommendation worked. Thank you
