Query Intersection Chart
- 2 Minutes To Read
-
Print
-
DarkLight
The Query Intersection chart is a multiple queries metric, consisting of a base query and up to two intersecting queries. It is designed 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.
The chart presentation for Query Intersection is a pie chart.
To configure a Query Intersection chart:
- Specify a title for the dashboard chart.
- Select the entity type for the metric, Devices or Users.
- Select a base query or leave empty for all entities.
- Select one or two intersecting queries.
- 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 and link on each of the slices of the pie chart will redirect you to Devices page displaying the corresponding list of devices.