How to display a customer score within reports?

[Anonymous]

Hello,

Our questionnaire consists of 50 different questions. In order to get a summary of how well each person answered, we would like to have a “weigth” for each question.

For example:

Question 1: Do you have quality processes?

Yes = 1 point

No = 0 point

Question 2: Which quality standard do you have ?

ISO 9000-1 = 1 point if checkbox is checked, 0 if unchecked,

ISO 9000-2 = 1 point if checkbox is checked, 0 if unchecked,

ISO 14000-2 = 1 point if checkbox is checked, 0 if unchecked,

Question 3: Do you ship to the U.S?

Yes = 1 point

No = 0 point

and so on…

At the end the questionnaire, we would like to compile and report a total score. In the above example, if the person answered

Question 1: Yes = 1 point

Question 2: Checked ISO 9000-1 = 1 point

Unchecked ISO 9000-2 = 0 point

Unchecked ISO 14000 = 0 point

Question 3: No = 0 point

Total Score = 2 / 5 = 40%

Is that something that can be done? If not, I know it can be done in Excel.

Thanks,

[ajoblingKeymaster]

If you use Radio Buttons for your responses (This allows just one answer) then the Radio Button Group (i.e. the question) can have a value attached to each answer.

The values can be added up at the end.

Be aware, however, that if a Radio Button Group is not answered at all then it will have the value of 0.

If you are using checkboxes for your responses (This allows multiple answers) then you need to add in some logic which is based on the responses. Each checkbox will need a corresponding input object. Then the behavior would be:

If ISO 9000 is checked then value = 1

If ISO 9000 is not checked then value = 0

[Author]

Posts