Skip to main content
Question

Averaging Select Rows

V
Forum|alt.badge.img+2

I am collecting grades for students, a few of the grade types have subcategories that need to be averaged (some of the nomenclature is strange as it’s being translated from another language). I need to calculate a “Values” score by averaging the “Honesty”, “Empathy”, “Lucidity”, Performance”, “Respect” scores. I’m trying to keep the table design very simple as we will need to eventually translate and teach non-English speakers how to use it. 

 

Is there a way to calculate averages only for select rows, by student? (I would like to calculate a Values score and a Property Respect score by averaging the relevant subcomponents). I understand I can see it with a View, but I want to be able to calculate the actual number to put in a clean interface view.

 

And if I need to collect this data monthly, are the columns I have for Month/Year the best way to do that, and we would just continue adding rows?

 

 

 

2 replies

TheTimeSavingCo
Forum|alt.badge.img+18

Is there a way to calculate averages only for select rows, by student?

 

I’d recommend a new table where each record represented a single value for a single student, and you’d use an automation to create that record

---

And if I need to collect this data monthly, are the columns I have for Month/Year the best way to do that, and we would just continue adding rows?

 

I’d also recommend a new table for this where each record represented a single student, value, and month year I think

 

I’ve set it up here for you to check out!

 

 

And the automation would look like this:

Trigger
Update record

 

Adam, Consultant @ The Time Saving Co
V
Forum|alt.badge.img+2
  • VLauren
  • Author
  • New Participant
  • 1 reply
  • March 21, 2025

Thank you! I should also be able to add scores that don’t have subcomponents that need to be averaged in this setup? (For example Math - each student will just have a Math score - not a Math score comprised of subcomponents).

 

How do you setup the rollup to take the average by student? I think this part gets tricky. For example I want Jerry to have a Values Score which is the average of 5 subcomponents, and I also want him to have a Math score which has no subcomponents that need to be averaged, but we could look at an average per month.

Reply


Most helpful members this week

Terms & Conditions