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 simple chart widget.
Mapping the Matrix Table into Your Dashboard
- In your Dashboard Data tab of your Settings, click Add Source and select the survey name.
- Click Add Field Group.
- Name the field group something like Matrix.
- Set the field type to Measure Group.
- Click Add Field Group.
- 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.
- Click Save.
Creating the Simple Chart Widget
- Navigate to the dashboard by clicking on the dashboard name in the top-left.
- Click Add Widget and select Simple Chart.
Qtip: You need to be in editing mode to create a widget. To get into editing mode click Edit Page in the top-right. If the box in the top-right is blue and says Done Editing, then you are in editing mode.
- On the widget editing pane to the right, click the Horizontal Bar icon under Chart Type.
Qtip: You will have to scroll down on the widget options to see all available options.
- Click Add Metric.
Qtip: Only add one metric for now. If more than one metric is added, the Set X Axis Dimension will no longer be an available option and you will not be able to complete the next step. Additional metrics will be added later.
- Click Set X Axis Dimension and select Matrix under Field Group.
- Click Add Metric four times to add the remaining four 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.
- Click on Count and, under the Metric dropdown, select Top Box / Bottom Box. Complete this step for each metric.
- Change the Box Range for each metric according to the following:
- First metric: Change the Box Range to 1 to 1.
- Second metric: Change the Box Range to 2 to 2.
- Third metric: Change the Box Range to 3 to 3.
- Fourth metric: Change the Box Range to 4 to 4.
- Fifth metric: 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.
- Change the Label on each metric to the match the appropriate matrix question scale point.
Example: In the example on this page, 1 to 1 is Extremely satisfied, 2 to 2 is Somewhat satisfied, 3 to 3 is Neither satisfied nor dissatisfied, 4 to 4 is Somewhat dissatisfied, and 5 to 5 is Extremely dissatisfied.
- Under Display Options, select Show data values.
- Click No under Stack Chart to change it to Yes.