Custom Chart

With the Custom Chart widget, you can graph one or more data series on a single chart. Charts may have dual, left and right, y-axes, and custom formats and colors.

Specify the Data Source

1. Click the Edit button or the Configure this resource link.

2. Specify the Data Source:

   • To display a chart you have defined in a report, click Load Chart Configuration from Report, select the report (1), make sure the chart is selected in the Chart to copy drop-down (2), and click Use (3).

     To preview the chart, click the Report Title. It will open the report for you to review charts in the report.

     

     The table is added to the widget. Click Save to save the chart in the widget.

   • Click Select Datasource to select objects relevant for the widget. See Data selection methods.

3. The data source is added to the widget.

Specify data series for the chart

1. Click Add Data Series for Left Y-AXIS.

2. Filter or search for the data series, select the one to use, and click Add Data Series.

   The groups available and the data series within these groups will depend on the object selected.

   

3. The data series is added to the chart. Define the Y axis:

   • Custom label for the Y axis.

   • Select Units to be displayed.

   • Select the chart type (line, column, area, ...)

   • Specify whether to the axis should show the sum of all data series (if the axis shows more data series).

     

4. To further define the data series, click More and configure the following options:

   • Edit the Display name for the data series

   • Select a custom color for the data series

   • Specify whether to display 95th percentile or trend line.

     

Specify data grouping

Group data to be displayed:

1. Select the Data grouping box.

2. Click Browse, select the database column to group data by, and click Add column.

3. To add a legend, click Browse, select a database column, and click Add column.

   

Specify the sample interval

Select the Sample Interval. By default, a single point or bar will be displayed for every 15 minutes. The data in each sample is summarized.

The Sample Interval can be as frequent as once a minute to once a week. You can even specify a sample interval that is longer than the reporting period.

Define data filtering

Decide whether to filter the results and if so, configure how to do it.

• Specify the number or percentage of top records to display.

• Select how you want to sort this selection of records from the Sort records by drop-down menu. The choices depend on the data series selected.

• Select either Ascending or Descending from the Sort order drop-down.

• Select the Data aggregation method required to summarize your data by time period.

• Click Advanced if you want to sort records using a secondary field.

If you want to sort by one metric first and then by another metric, click Advanced, then click Select Field, and specify the sorting.

Preview the widget and save it

Click Preview Resource to see what the custom chart will look like. Close the preview and make any changes.

Click Save to submit your configuration.