Grouping data in charts


This topic describes how to group data in a chart to avoid overloading the browser.

When the number of data points in a time range exceeds the capabilities of the chart package, the chart package groups several data points into one. You can now control the values that are displayed on the chart for this aggregated group of points by selecting one of three options: minimum, average, or maximum.

Related topic


Because you can add a category multiple times, you can graph the data from one category as the maximum and use the same category a second time for the same data and show it as the average. The tooltip in the chart displays the value—maximum, average, or minimum based on the current data grouping of the chart. These values are visible only after you enable the Data-Grouping option.

image2022-6-27_13-12-21.png

Important

It is important to understand that Data-Grouping and Data-Granularity are different features. For Data Granularity usage and examples, see Usage-scenarios

To enable and disable data grouping

  1. In the More Actions dialog box, click Data-Grouping tab. 
    image2021-11-24_13-42-46.png
  1. Select Enable Data-Grouping. This option is enabled by default.
    Use the toggle button to disable data grouping. A warning message is displayed indicating that disabling Data-Grouping might result in poor browser performance when you display a large amount of data.

    Warning

    While it is possible to disable Data-Grouping, we strongly discourage it. Disabling Data Grouping can overload browser resources.

  2. Select one of the following options:
    • (Default) Show Maximum Value in Sequence
    • Show Average Value in Sequence
    • Show Minimum Value in Sequence
  3. Click Apply to save the changes.

After you enable the Data-Grouping option, the tooltip in the chart displays one of the following values based on the selected data grouping of the chart:

  • Maximum
  • Average
  • Minimum

Important

Data Grouping takes place only when there are a large number of data points. For example, six months or more of hourly data might result in data grouping. The results vary depending on various criteria, such as screen resolution, browser window size, and the total number of intervals to display.

CR-8.jpg

The same value appears in the chart legend above the values of a given metric.

CR-9.jpg

The interval marker displays the interval range.

CR-10.jpg

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*