Subject: Seeking Help on Calculating Averages from List Values in a Single Field
Hello everyone,
I’m looking for some advice on a technical challenge I’m facing.
Background:
I’ve created a game where participants rate a topic on a scale of 1 to 5 and try to guess the ratings of other group members. As the number of participants has grown, I would like to add a feature that displays the average rating for each topic based on past participant responses.
Problem:
Currently, the responses for each topic (30 in total) are stored as a list within a single field. As a result, the list items are not treated as separate fields or list values, making it impossible to calculate totals or averages. There are nearly 100 entries of historical data, and the number is increasing, so I am looking for a solution that does not involve manually entering data into the database. Additionally, I’ve managed a workaround for preventing duplicate entries in the list by incrementally adding 5 to each item.
Does anyone have a solution or know a more efficient way to calculate averages and handle these list values? Any advice or suggestions would be greatly appreciated!
Thank you!