Hello! I am somewhat new to airtable so still trying to figure out some basics.
What I am trying to do here is take the average values of each categories per seven days and average them. Is this possible? I.e. I would like to take the measurement of weight in lbs from days 1-7 and average that giving the result in another column, then for 8-14, 15-21, etc . . . I want to do this also for the columns as well. So far I cannot find a way to do this.
Bonus: If it’s possible to specify this by the Date field every seven days starting on a certain day even better!
Some quick thoughts - unlike excel’s cell by cell approach, Airtable runs its formula once per row. Meaning if you need to reference one row from another, you’re either using linked records or making use of a script instead of a formula.
But you might be able to get away with grouping and the summary bar. This is the simplest solution.
Combine days into the same row together. Then using lookups and formula fields, you’d calculate their averages however suits you.