Query Intersection Chart
  • 13 Jul 2022
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Query Intersection Chart

  • Dark
    Light
  • 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.

QueryIntersectonBig.png

Query Intersection is displayed as a pie chart.

To configure a Query Intersection chart:

  1. Give a title to your chart.
  2. You can add a description if you want.
  3. Select the module for the chart, Devices or Users.
  4. Select or create a base query or leave empty for all entities. Learn more about creating a query.
  5. 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.
  6. 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 the link on each of the slices of the pie chart to see the Devices page displaying the corresponding list of devices.


Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.