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
  • 4 replies
  • 24 views
G
Forum|alt.badge.img+1

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!

4 replies

PeeyushBansal
Level 7 ●●●●●●●
Forum|alt.badge.img+46
  • PeeyushBansal
  • Level 7 ●●●●●●●
  • January 26, 2026

​@GaryF 

 

You can add a statistic table visualization to your report.

In the table settings:

Enable Top Box and select “Excellent” and “Good.”

Enable Bottom Box and select “Poor” and “Very Poor.”

Ensure “Show Percentages” is enabled.

The “Average” row will appear as its own percentage.

Statistics Table Example

Best Regards, Peeyush
G
Forum|alt.badge.img+1
  • GaryF
  • Author
  • January 26, 2026

Hi ​@PeeyushBansal,

 

Thank you very much for the information. Unfortunately, in my statistics table I see slightly different settings, and I am not sure why.

To get here, I:

  • Hit Insert > Questions > My Likert Matrix Question
  • Ensured the visualization was set to statistics table
  • Set top box to 2 and bottom box to 2

At this point, if I select Mean it gives a number around 8, while top and bottom box are both between 0 and 1. Additionally, I am not seeing a metric dropdown.

 

Here are some photos to try and further explain. Thank you again for the help!

Below this is just the option to remove the visualization.

G
Forum|alt.badge.img+1
  • GaryF
  • Author
  • January 28, 2026

Hello! If anyone has any ideas on how to best go about this, or if it is even possible, I would really appreciate the help. Thank you very much!

Tom_1842
Level 8 ●●●●●●●●
Forum|alt.badge.img+28
  • Tom_1842
  • Level 8 ●●●●●●●●
  • January 28, 2026

The settings look different because I think Peeyush is using the Legacy Results-Reports and you are working in the Reports tab. If your mean values are in the 7s, I would check on the Recode values of the Matrix question scale points. You probably want them to be 1 to 5, where 1 is Very Poor and 5 is Excellent. The Recode values will also affect what gets considered a top box/bottom box to the Statistics Table, where 1 and 2 are bottom and 4 and 5 are top. The value depicted in the statistics table for bottom/top boxes is the proportion of respondents that fit into that box. In the below example for statement 1, the statistics table shows a top box of "0.45", and the bar chart depicts "Good" at "15%" and "Excellent" at "30%" which sums to 45%.

I am not sure how to include the proportion of respondents that select "Average" in the statistics table. However, you can make your own fields using Bucketing which can group the options into 3 buckets: “Top Box”, “Average”, “Bottom Box”. The created fields can then be included in a Data Table which will resemble the format of the Statistics table. The metric type can be adjusted to be percentages.

 

Terms & ConditionsAccessibility statement