I 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!

Hi,I would still use scoring. For your existing data, you can use a custom metric as @Sachin Nandikolsuggested, 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 orexports:

Thank you so much for your input, @Sachin Nandikoland @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 answerdivided by the total number of questions which was24) and then used that to score/find the mean score. @vgayraudI will create the ED field for the next iteration! Thanks again, everyone!

Formula Fields- limit to the number of variables

Formula Fields- limit to the number of variables | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded