
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 05, 2022 01:47 AM
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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 05, 2022 02:18 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 05, 2022 02:18 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 11, 2022 06:37 AM
This was exactly what I needed @Alessio_Monino - thanks for the reply!
