Field Summary Chart
  • 22 Nov 2023
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Field Summary Chart

  • Dark
    Light
  • PDF

Article Summary

The Field Summary chart is a single query metric, consisting of a single query and a chosen field. Use this chart to present the calculated outcome (average, count, count true, count false, sum) on the values of the chosen field across the data-set given by the query. You can choose to display data either as a chart or as a timeline chart. You can use the timeline chart to track the values of a field over time.

FieldSummaryN.png

To configure a Field Summary chart:

  1. In the Chart title text box, enter a title for the chart.

  2. In the Description text box, you can add an optional description.

  3. From the Widget list, select Field Summary Chart.

  4. Chart presentation – Select the chart presentation, bar chart or timeline view.

  5. Chart Description – specify a chart description type: 'Default', 'Empty', or 'Custom'. If you choose 'Custom' type a value of up to 250 characters.

  6. From the Module list, select an asset module.

  7. From the Query list, select or create a base query or leave empty for all entities. Learn more about creating a query.

  8. Text color – select the color of the text to display.

  9. Select a field to run the function.

    • The available functions are based on the type of the field you select and vice versa. The fields available depend on the module you select.
    • If you chose the Average or Sum function, you can select only integer type fields.
    • If you chose the Count function, you can select all the fields except boolean type fields.
    • If you chose a Count True or Count False function, you can select only boolean type fields.
  10. Select a function to calculate:

    • Average
    • Count
    • Count True
    • Count False
    • Count Sum
  11. Number format – Set the number format for the display:

  • Float (default)
  • Ceiling – round the value up to the next integer
  • Floor – round the value down to the preceding integer
  • Round – round the number according to rounding rules when the value is < .5 - Round down, when the value is > .5 - Round up
  1. Timeline Settings - When you choose timeline view, set the following:

    • In Aggregate by, select an aggregation time period: Hour, Day, Week, Month Quarter, or Year. Query results for weekly, monthly, quarterly, and yearly time periods are aggregated based on the average values for the selected time period. Each data point for weekly aggregation is the average of all daily values since the last weekly period. And each data point for the monthly aggregation is the average of all daily values since the last monthly period. The legend reflects the time period selected.

      Note:
      On the daily aggregation chart, you can click through to the asset list.
    • Set one of the following:
      • Show results in the last x days – select a number and a time period, days, weeks, months or years.
      • Or show results in date range – Set a start and end date.
        In the graph that is created when you click on a point in the graph it opens the query in the Devices page.
  2. You can also:

  3. Click Save.

Viewing a List of Assets Represented by the Chart

Once the chart configuration is saved and it has been populated with data, you can click the chart to see a list of the assets represented by it in one of the asset pages. The query configured in the chart is populated into the query bar above the list and into the Query Wizard.

NOTE
There are cases when the query configured in the chart was written or edited in the query bar of the Queries page as an Axonius Query Statement, and not in the Query Wizard, and then run. If you configure a chart with that query and then click the chart to see a list of assets, the query parameters are not populated into the Query Wizard.

Examples

For example, the number of Windows OS type devices on the system and the average RAM usage across all devices for last scan. Click on the value to open the query in the devices page.

image.png

For example, the average of total RAM on devices see in the last 7 days. Mouse over to see the values on each point. Click on a data point to open the query on the devices page.
FieldSumaryTimelineRN.png


Was this article helpful?

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.