Community Groups are officially here!
We've released Groups, a new feature that enables us to connect community members of similar industries and interests in a shared, private space. You can check out all of the details here, including information about who can join, how to join, and what Groups are currently offered. Please leave your feedback through this Community Groups Feedback Survey.

How to translate a matrix question into a widget?

Joelle_Winter WisconsinCommunity Member, Qualtrics Brand Admin Qubie ✭
edited June 23 in CX Dashboards

I have the following question in a recent survey:

The column headers are coming over as 1, 2, 3 - How do i change it to read the actual titles?

Also, what is the best widget/way to show the results in a dashboard for a matrix question(s)?


  • kpaddock
    kpaddock Houston, TXCommunity Member, Qualtrics Brand Admin Qubie ✭
    edited June 2020

    In your survey editor, you can click the settings gear next to the question and select "Recode Values" to make sure the column headers are correct. Then in your dashboard settings, you can recode the question so that the column numbers recode to the header labels. See attached.

    As far as the best widget, you may have better luck creating some embedded data fields in the survey flow to help you out with calculations. For example, create a field called "NOVO_Utilized" which is set to a 1 or 0 depending on if they checked it or not. Then you can create 9 Numeric Value variables in your dashboard settings, which will let you use a bunch of different widgets. For example, use a Gauge chart to display the average of NOVO_Utilized, set it to percentage, and you will see a percentage of how often that response was checked.

    EDIT: I did the classic blunder of not attaching the image the first time. In this image, column 1's header is "sp1", column 2's is "sp2", column 3's is "sp3". Here they are just recoded to sp1, sp2, and sp3, but you can change to numbers.

  • ChristianB
    ChristianB ProvoModerator, Community Member, Qualtrics Brand Admin Moderator

    Hi @Joelle_Winter! If you have not yet already, I’d recommend reviewing this support page on Matrix Statements in a Single Widget to help you get started. If you still have questions after reviewing the linked support page, you'll want to reach out to the  Support team, as they are best equipped to help answer questions and provide support! :)