Query Intersection Chart
  • 2 Minutes To Read
  • Print
  • Share
  • Dark
    Light

Query Intersection Chart

  • Print
  • Share
  • Dark
    Light

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.

image.png

The chart presentation for Query Intersection is a pie chart.

To configure a Query Intersection chart:

  1. Specify a title for the dashboard chart.
  2. Select the entity type for the metric, Devices or Users.
  3. Select a base query or leave empty for all entities.
  4. Select one or two intersecting queries.
  5. 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):

image.png

Click and link on each of the slices of the pie chart will redirect you to Devices page displaying the corresponding list of devices.

Was This Article Helpful?