- 02 Jan 2022
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Matrix Data Chart
- Updated on 02 Jan 2022
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
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:
- Give a title to your chart.
- You can add a description if you want.
- 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:
- Select stacked bar chart
- Select the asset type for the chart, Devices or Users.
- Select or create a base query or leave empty for all entities. Learn more about creating a query.
- You may add multiple base queries.
- Select a saved query or create a new one from the Intersecting query
- You can add up to three intersecting queries.
- Define the default data sort. By default, the data will be sorted by descending values.
- 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.
- Select table presentation
-
Select the asset type for the chart, Devices or Users.
-
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.
-
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. -
Select Add rows total to show the total number of unique devices or users for each row.
-
Select Add columns total to show the total number of unique devices or users for each column.
-
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.
-
Define the default data sort. By default, the data will be sorted by descending values.
-
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.