Averaging Select Rows

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:

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.

Hey ​@VLauren!

Yes, all of the above is possible. However, how to achieve this will depend on what your current architecture looks like. 
 

Would you mind sharing some more screenshots of your different tables? 
 

Mike, Consultant @ Automatic Nation 

Hmm, not entirely sure I follow.  I’ve made some edits to the original base, if you could let me know 

where I got it wrong I’ll see what I can do!