How to display a customer score within reports?

Home Forum Reporting How to display a customer score within reports?

Tagged: , ,

This topic contains 1 reply, has 0 voices, and was last updated by  Anonymous 9 years, 3 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #266

    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,

    #4701

    ajobling
    Keymaster

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.