How to create a report on survey results that show average score as well as comments

[Ryan S]

We have configured one survey to measure customer satisfaction with IT services. The survey has 6 questions: 5 are scored 1-4 and the 6th question is open-ended "comments." I want to produce a report that shows each survey response as a single line-item with both the average of the first 5 questions as well as the comments. How can I do this?

For example:

Survey instance	Question 1 Score	Question 2 Score	Question 3 Score	Question 4 Score	Question 5 Score	Average Score	Comments
AINST0001	1	1	1	1	1	1.0	I received really bad service
AINST0002	4	4	4	4	4	4.0	Great service?
AINST0003	3	3	4	2	3	3.0	<null>

Comments are given a score of '-1' (I assume this is default behavior) so that's caused me issues and why I usually have to filter the comments separately, but I really want the above and can't figure it out. We have regular reporting and PA available.

[Cody Smith _ Cl]

Hello Ryan,

Look into using 'Pivot Tables' for this. The table to use is Assessment Instance Question [asmt_assessment_instance_question] (or the legacy Survey Response [survey_response] table, if you're using it).

If my answer was helpful, or solved your issue, please mark it as Helpful / Correct.

Thank you,

Cody Smith

[Ryan S]

Hi Cody,

I don't see how a pivottable will show me this information. A pivottable will calculate the average score for me, but not display the individual results or comments.

[Tracy Davis]

I spent so much time trying to do this.

We have one question regarding overall satisfaction, I ended up just reporting on that one single question.

I created a separate report for comments - and then another one that showed comments and full scores whenever the overall satisfaction rating was under a certain number, that way we could see the comments associated with the low scores.

[Ryan S]

Tracy, how did you do the latter? That sounds like exactly what i need.