Display sum of questionnaire response scores in banded groups
Content
Hello. I'm trying to accomplish the following from a scored survey in a checklist task that we ask our new hires to respond to. Each response within each of the 20 questions has a different point value, and I would like to:
- Sum the scores of a person's responses
- Slot the total score into one of three bands that are based on a range of scores, e.g., 1-26, 27-56, 54-80
- Report on a dashboard the number of surveys in each of the three bands.
I'm having trouble getting the total sum of an individual person's survey. I can see the response score for each person's answer, but I can't get all of the responses summed. Does anyone have an idea of how I can accomplish this?
Tagged:
1