How to translate a matrix question into a widget?

Question

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 · Answer

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.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded