+1I need to calculate the average of 24 different fields and formula fields seem to be capped at 20 variables. I would like this to be done in the data set because I am building a report for it within Qualtrics. Any ideas about how to do this since I've already done my data collection? I think in the future, I will create an embedded field that calculates the value, so any tips on executing that would also be appreciated.
Many thanks for your consideration!
Best answer by vgayraud
Hi,
I would still use scoring. For your existing data, you can use a custom metric as
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:
+1The scoring function should allow you to get what you need, and it’s retroactive.
Thank you so much!
+1The scoring function should allow you to get what you need, and it’s retroactive.
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!!
+44Hello
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.
+58Hi,
I would still use scoring. For your existing data, you can use a custom metric as
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:
+1Thank you so much for your input,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.