I have a question about calculating averages. I’m not exactly sure if it’s currently possible to do this with Airtable, and I have been searching for a while, so if anyone knows how I can do this, I would appreciate the help.
So I have attached an image of an example of the kind of base we are using. My organization will be using this for user acceptance testing, and each base will consist of a table for each of the testers. Each table is essentially identical. They all have the same columns, and everything up to the breaker/divider (Product Area, Acceptance Requirement, and Instructions) will have identical records as well across tables. Each tester has their own table, and fills in the fields after the divider (Status onwards).
Basically, we would like to be able to calculate the average status, usability rating, and Time on task for each of the items. Meaning that, we want to be able to take each of the tester’s Time on task record entries, and calculate the average for them. However, since each of the testers are entering their time, usability rating, and status in separate tables, I have yet to figure out if this is possible.
For example, for item number 1 (the first record in the table), we would like be able to find out how long it took the testers on average to complete that specific item. We would like to do the same for the usability rating and status, so in all of these cases I would need to be able to pull data from all of these tables into one record so that we can see the average across users (and therefore across tables).
I am pretty lost trying to figure this out, so any help would be much appreciated.