Matrix Data Chart

The Matrix Data chart lets you visualize in a stacked bar chart a data matrix that consists of multiple data intersections between one or multiple base queries and up to three intersecting queries.

To configure a Matrix Data chart:

1. In the Chart title text box, enter a title for the chart.
2. In the Description text box, you can add an optional description.
3. From the Widget dropdown, select Matrix Data Chart.
4. Under Chart presentation, select the chart presentation style you want.
5. Configure the chart according to the presentation style as described in the procedures below.

Configuring a Matrix Data Stacked Bar Chart

You can present the data as a stacked bar chart:

1. Select the stacked bar chart.
2. From the Module dropdown, select an asset module.
3. From Base query, select or create a base query or leave empty for all entities. Learn more about creating a query.
   • You may add unlimited base queries.
4. From Intersecting query, select a saved query or create a new one
   • You can add up to 30 intersecting queries.
5. Select Hide Total calculation to prevent totals from being displayed. See Hiding the Total Asset Count.
6. Under Segment by, select how to display the data:
   1. Select Percentage and Show Percentage to see a percentage/normalized chart. See Configuring the Stacked Bar Chart in a Percentage/Normalized Mode.
   2. Select Number and Show Number to see an absolute chart showing the actual asset counts.
7. Click Save.

Each bar in the stacked bar chart visualizes the intersections between a specific base query and each of the specified intersecting queries.

An example of the percentage/normalized chart:

Adding Groups to a Matrix Data Chart

Use groups to show intersections for more than one asset type in the same chart. Each group has its own asset type, base queries, and intersecting queries.

Permissions: To add or edit a chart, you need the Dashboards > Charts > Add or Dashboards > Charts > Edit permission.

To add a group:

1. In the chart wizard, select Matrix Data Chart and the stacked bar chart presentation.
2. In Group 1, set the module, the base queries, and the intersecting queries.
3. Click Add group.
4. In the new group, set the module, the base queries, and the intersecting queries.
5. To remove a group, click Remove group next to its title.
6. Click Save.

• A chart can have up to 5 groups. When the chart has 5 groups, Add group is disabled, and the tooltip "Up to 5 groups" appears.
• When a chart has more than one group, each group can have up to 20 base queries and 10 intersecting queries.
• When a chart has more than one asset type, each legend name shows the asset type in brackets, and the chart doesn't show a total.
• When a chart has more than one group, the table view isn't available.
• On an asset profile dashboard, all groups use the asset type of the profile.

Example: A Matrix Data chart has Group 1 for Devices, with the base query "Windows devices", and Group 2 for Users, with the base query "Admin users". Each group shows its own bars.

Configuring a Matrix Data Table

You can present the Matrix data as a table. This shows the common values between two queries, for instance Operating System and Devices.

To configure a Matrix Data Table chart:

1. Select the table presentation.

2. From the Module dropdown, select an asset module.
3. The Base query defines the rows of the table. From the Base query list, select a saved query or create a new query or leave empty for all entities. From the Field drop down select a field. You can choose an aggregated field, or a field from a specific adapter.
4. The Intersecting query defines the columns of the table. Select a saved query or create a new one from the Intersecting query or leave empty for all entities. From the Field drop down select a field. You can choose an aggregated field, or a field from a specific adapter.
   Learn more about creating a query.
5. Select Add rows total to show the total number of unique devices or users for each row.
6. Select Add columns total to show the total number of unique devices or users for each column.
7. Select Show results with no intersecting values to show results on the table where there are no values in common between the base query and the intersecting query.
8. (Optional) To color the cells by count, enable Set threshold colors and select Static or Dynamic. See Setting Threshold Colors.
9. Click Save.

The top 1000 columns are displayed. The table shows the intersection between all assets which have a value in both of the fields.

Threshold colors apply to the count cells only. The row totals and column totals keep their usual look. The thresholds work with any number of intersecting queries. In the stacked bar view, only Static thresholds are available, and the chart needs one intersecting query. When you change a chart from the table view to the stacked bar view, Dynamic changes to Static.

Example: A Matrix Data table shows the device counts of three base queries against four intersecting queries. Enable Set threshold colors, select Dynamic, and select red. The cells with the most devices are dark red, and the cells with few devices are almost white.

You can export the table to a CSV file.

Click on an asset bar or table cell to view the Asset summary for the displayed assets. Click the Asset Page to view the assets on their relevant Asset page with the query populated in the Query Wizard.

You can change between the chart presentation styles. When moving from stacked bar chart to Matrix data table, only the first query is used.