.png?sv=2019-07-07&sig=t03oibWtB2U7vkBfNruBpigAonFiZHEFC9MdV%2Bp6B3w%3D&spr=https%2Chttp&st=2022-12-05T23%3A57%3A35Z&se=2022-12-06T00%3A07%3A35Z&srt=o&ss=b&sp=r){kind=logo}
Query Intersection Chart
- 13 Jul 2022
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Query Intersection Chart
- Updated on 13 Jul 2022
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
The Query Intersection chart is a multiple queries metric, consisting of a base query and up to two intersecting queries. You can use this chart to measure the number of entities (devices, users) of the intersecting queries out of the base query and highlight intersection between the intersecting queries, showing the result in percentage out of the total base query entities.
Query Intersection is displayed as a pie chart.
To configure a Query Intersection chart:
- Give a title to your chart.
- You can add a description if you want.
- Select the module for the chart, Devices or Users.
- Select or create a base query or leave empty for all entities. Learn more about creating a query.
- Select one or two intersecting queries, or create new intersecting queries.
As you configure the chart, a preview is created in the left pane.
You can assign chart colors to asset count thresholds to easily evaluate the current environment. See Setting Asset Count Threshold Colors. - Click Save.
A pie chart is generated, with the following data:
Single Query Intersection
| Slice Type | Slice Data | Slice Color | Slice Label |
|---|---|---|---|
| Intersection #1 | The intersection between base query AND the intersecting query |
The color of each slice depends on its size: 1. Red - 0%-25% 2. Amber - 26%-50% 3. Blue - 51%-75% 4. Green - 76%-100% |
Selected intersecting query name |
| Remainder | Remainder of the data - The base query data that does not intersect with the select query | Grey | Depend on the selected base query: - Remainder of [intersecting query name] - Remainder of all devices - Remainder of all user |
Two Query Intersections
| Slice Type | Slice Data | Slice Color | Slice Label |
|---|---|---|---|
| Intersection #1 | The intersection between: [base query] AND [intersecting query #1] AND NOT[intersecting query #2] |
based on Axonius color palette | Intersecting query #1 name |
| Intersection #2 | The intersection between: [base query] AND [intersecting query #2] AND NOT[intersecting query #1] |
based on Axonius color palette | Intersecting query #2 name |
| Intersection #1+#2 | The intersection between: [base query] AND [intersecting query #1] AND [intersecting query #2] |
based on Axonius color palette | Intersecting query #1 + Intersecting query #2 names |
| Remainder | Remainder of the data - The base query data that does not intersect with the selected queries: [base query] AND NOT ([intersecting query #1] OR [intersecting query #2]) |
Grey | Depend on the selected base query: - Remainder of [intersecting query name] - Remainder of all devices - Remainder of all user |
For example, creating a Query Intersection chart with a base query of all devices, and devices seen in the last 7 days and with devices seen in the last 30 days as 2 intersecting queries will be resulted in (last 30 days contains all last 7 days devices):
Click the link on each of the slices of the pie chart to see the Devices page displaying the corresponding list of devices.