The scoring function should allow you to get what you need, and it’s retroactive.

Thank you so much!

I added the scoring options which calculates the total across the measures, but I’ve not been able to figure out how to get the average score of the questions. Formula fields is what I’ve been mostly using, but they don’t allow you to use scores within them. Any additional thoughts? Thank you!!

Hello ​@sto1234,

The best approach, in my opinion, would be to use formula fields. You can divide your 24 questions into two sets of 12 each. Create one formula to calculate the sum of the first set and another for the second set. Then, combine both results and divide by 24 to get the average.

For the data you've already collected, you can try building a custom metric in the dashboard. Use that metric as the source and it will give you the average value as needed.

Hi,

I would still use scoring. For your existing data, you can use a custom metric as ​@Sachin Nandikol suggested, but you can base it directly on the score:

However, for the future, you should map your score and mean to ED fields in your survey flow. Those will be usable directly in dashboards or exports:

Thank you so much for your input, ​@Sachin Nandikol and ​@vgayraud! This is helpful to consider! Unfortunately, the license that my university has doesn’t have dashboards or custom metrics. It also doesn’t permit formula fields to pull from other formulas fields. However, I did use scoring and entered a decimal number for each answer (the score for that particular answer divided by the total number of questions which was 24) and then used that to score/find the mean score. ​@vgayraud I will create the ED field for the next iteration! Thanks again, everyone!