Trying to organize sales data

[UrbnJ]

Hi everyone!

I'm trying to organize my sales data in my Airtable base.

I add the data through CSV upload. For every day of sales I add I add a new column to my sales data table.

Now I want to run automatic calculations on the data. To give an example: if sales for a particular product are decreasing for a few days in a row I want to make this visible in Airtable, or automatically send an email as a warning. 

Now the problem is that if you create calculations to do this you do that for the existing columns, but every day I'm adding a new column to the table, so than the calculation won't include the newest data.

Does anyone know how to deal with this?

[Brian_Sweeny]

It seems like you are structuring your data in Airtable as you would in Excel. Properly structured data in Airtable will never include adding a new field (column as referred to above). You should probably flip your x and y axis and have each day be a new record (or row in excel speak), then explore airtable’s rollup field functionality to do the calculations. If you want to dive deeper, feel free to schedule a session with me!