Matrix Statements in a Single Widget

About Viewing Matrix Statements in a Single Widget

Matrix table questions are useful for asking about multiple items in one question. And if you’ve asked these questions together, you probably want to report on their data in the same widget. This page outlines how to view all of the statements of a single answer matrix table into one horizontal bar widget.

Mapping the Matrix Table into Your Dashboard

1. Go to your dashboard’s dataset.
   
2. Click Add Field Group.
3. Name the field group something like Matrix.
4. Set the field type to Measure Group.
5. Click Add Field Group.
6. Click on the dropdown that says Not Mapped, select your Matrix Table from the list of survey questions in the dropdown, and select Map all.
   
7. Click Save.
   

Creating the Horizontal Bar Chart

1. Go back to your dashboard by clicking the arrow next to Settings.
   
2. Click Add Widget.
   
   
3. Select Horizontal bars.
   Qtip: You need to be in editing mode to create a widget. To get into editing mode click the pencil icon in the top-right. If it says Done Editing, then you are already in editing mode.
4. Under Metrics, click Add.
   
   
   Qtip: Only add one metric for now. If more than one metric is added, the y-axis will no longer be an available option and you will not be able to complete the next step. Additional metrics will be added later.
5. Under Y-axis, click Add, then select Matrix.
6. Under Metrics, click Add 4 more times to add the remaining 4 metrics.
   
   Qtip: The example we use on this page is a matrix table with a 5-point scale, but the steps can be modified for whatever number of scale points you have. For example, for a 6-point scale, you’d have 6 metrics total.
7. Click one of the metrics.
   
8. Under the Metric dropdown, select Top Box / Bottom Box.
9. Change the Label to a scale point.
   Qtip: We recommend going in order from lowest to highest. (E.g., Extremely dissatisfied, somewhat dissatisfied, neither satisfied nor dissatisfied, somewhat satisfied, and then lastly, extremely satisfied.)
10. Change the Box Range for each metric according to the following:
    • Extremely dissatisfied: Change the Box Range to 1 to 1.
    • Somewhat dissatisfied: Change the Box Range to 2 to 2.
    • Neither satisfied nor dissatisfied: Change the Box Range to 3 to 3.
    • Somewhat satisfied: Change the Box Range to 4 to 4.
    • Extremely satisfied: Change the Box Range to 5 to 5.
      Qtip: The example we use on this page is a matrix table with a 5-point scale, but the steps can be modified for whatever number of scale points you have. For example, for a 6-point scale, you’d have 6 metrics, and the sixth metric’s box range would be 6 to 6.
11. Select Options.
    
12. Under Format, select Percent.
13. Complete steps 7-12 for each metric.
14. Go to Display.
    
    
15. Expand Data values.
16. Select Show data values.
17. Go to Chart styles.
    
18. Selected Stacked chart.
19. If needed, you can adjust the chart’s colors and the order of items under Legends.