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 3 intersecting queries.

To configure a Matrix Data chart:

1. Give a title to your chart.
2. You can add a description if you want.
3. Select the chart presentation bar chart, or table.

Configuring a Matrix Data Stacked Bar Chart:

You can present the data as a stacked bar chart:

1. Select stacked bar chart
2. Select the asset type for the chart, Devices or Users.
3. Select or create a base query or leave empty for all entities. Learn more about creating a query.
   • You may add multiple base queries.
4. Select a saved query or create a new one from the Intersecting query
   • You can add up to three intersecting queries.
5. Define the default data sort. By default, the data will be sorted by descending values.
6. Click Save.

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

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.

1. Select table presentation

2. Select the asset type for the chart, Devices or Users.

3. The Base query defines the rows of the table. From the Base query drop down, 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. Define the default data sort. By default, the data will be sorted by descending values.

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.

You can export the table to a CSV file.
You can change between the presentations, in this case when moving from stacked bar chart to Matrix data table, only the first query is used.