I sell tickets to shows.
I do these shows in different cities.
Every day, I receive a report from each city which tells me total tickets sold and total $ value of those tickets.
So, my sales table (if grouped by city) looks like this:
11/1/19 325 Tickets $4,675
11/2/19 330 Tickets $5,150
11/3/19 345 Tickets $5,325
11/1/19 600 Tickets $7,575
11/2/19 650 Tickets $8,420
11/3/19 700 Tickets $9,380
11/1/19 100 Tickets $1,250
11/2/19 125 Tickets $1,650
11/3/19 150 Tickets $1,850
And so on…
My sales team needs to know things like:
How many tickets did we sell in City 1 yesterday?
How many tickets are we averaging daily in City 2?
In a spreadsheet, it would be easy, I would just create a formula that subtracts yesterday’s total from today’s total and my answer would be “Tickets sold today”.
Obviously, I can’t do that in airtable (or at least I don’t know how) because formulas only work within the same record.
I’ve thought about creating a zap that shoots today’s total to a spreadsheet which performs the calculation and then sends the result back to airtable but that seems cumbersome and inefficient to me. Maybe it’s the best way…