Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Tracking bi-weekly Sprint score through a form and calculating averages

Topic Labels: Base design
Solved
Jump to Solution
167 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I need to create a form for our sprint reviews, in which our partners can anonymously rate their confidence and commitment to the development. I have created the form with no problem, but I would like to track the average rating per question and per sprint, so I can follow the progress over time.

How do I calculate an average grouped by the specific sprint?

AB688B14-1FDA-41AD-A905-5DCFEB0BE14A_1_201_a

1 Solution

Accepted Solutions

hi @GHR,
I would suggest separating the structure in two separate tables: one for sprints and one for questionnaire answers. Then you could use a linked record field to link each questionnaire answer to a specific sprint. This would allow you to, from the sprints table, create a rollup field that calculates the average for that particular sprint.

Hope this helps!

Website: alessiomonino.com
Calendly: Calendly - Alessio Monino
Email: alessio.monino@gmail.com

See Solution in Thread

2 Replies 2

hi @GHR,
I would suggest separating the structure in two separate tables: one for sprints and one for questionnaire answers. Then you could use a linked record field to link each questionnaire answer to a specific sprint. This would allow you to, from the sprints table, create a rollup field that calculates the average for that particular sprint.

Hope this helps!

Website: alessiomonino.com
Calendly: Calendly - Alessio Monino
Email: alessio.monino@gmail.com

This was exactly what I needed @Alessio_Monino - thanks for the reply!