Grouping answer choices from a Likert Matrix in a Qualtrics Report | Experience Community
Skip to main content
Question

Grouping answer choices from a Likert Matrix in a Qualtrics Report

  • January 25, 2026
  • 0 replies
  • 3 views

Forum|alt.badge.img

Good Afternoon,

I have a survey with a few Likert Matrices with the following format: Multiple questions asking for respondents to rate their satisfaction with different areas of their employment on the scale: Excellent, Good, Average, Poor, Very Poor.

I also have a report for this survey, and I see that I can display these matrix results in a data table or a statistics table.

Here is where I am looking for help. I would like to display the results for each matrix in the following format, in a Qualtrics report:

  • Above average (Group Excellent and Good)
  • Average
  • Below average (Group Poor and Very Poor)

Additionally, I would prefer to display these as percentages or proportions, rather than counts.

I have gotten pretty close to what I would want using a statistics table with top box and bottom box, but I am not sure how to also show the proportion of average results in that format.

 

Thank you very much for any help or suggestions, I really appreciate it!