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.

[Ryan S]

Hi Tracy, could you share your solution on the latter--where you have the full scores and the comments together?

[Priya Thakur2]

Hi @Tracy , I do have same requirement, could you please share in details what you did.