Chart aggregation
This chart displays information as a series of data points over an x-axis of time. The data points can be displayed as points, lines, or columns as this chart type offers several options for visualization.
Creating a chart aggregation
Go to Data Search and open the required table.
Perform the required operations to get the data you want to use in the chart.
You must group your data to generate a Chart aggregation.
Select Additional tools → Charts → Plots → Chart Aggregation from the query toolbar.
Click and drag the column headers to the corresponding fields. This chart requires you to select one field:
Required field Data type Signals float, integer, duration You can drag more than one column to the Signals field..
The chart aggregation is displayed. Click the chart series names to show/hide them.
If the columns added to the chart generate a large number of points in the graph, the application will warn you that it may cause a browser malfunction.
Customizing your chart aggregation
When the chart is displayed, chart tool icons are available in the upper-right of the window frame. Click the paintbrush icon to display the options for customizing your chart. There are three different categories:
Graph visualization
Use these options to choose how you want to visualize the chart.
In this area, you can change the font size clicking the A+ and A- buttons and select the required type of chart:
| Line chart | This is the default style, which displays the data points connected by straight lines. |
|---|---|
| Area chart | This style fills in the area below the lines with colors. |
| Column chart | This style displays the data points as vertical bars. |
| Spline chart | This style displays the data points connected by smooth curved lines; useful for showing gradual changes. |
| Area spline chart | This style creates a spline chart and fills in the area below the lines with colors. |
| Points and averages | This style displays the individual data points along with lines representing the data average. |
Specify the options for the graph on which the chart is plotted in the Graph Options section:
| Stacked | This option groups data sets horizontally to facilitate comparison. |
|---|---|
| Stacked 100% | This option applies the relative percentage of the different data points on a y-axis of 0-100%. |
| Show grid | This option shows/hides the grid in the background. |
| Null to zeros | This option transforms null values into 0. |
| Show chart points | This option shows/hides data points. This option is not available if you have selected the Points and averages or Column chart style. |
| Show all series | This option shows the complete series. This process may take several minutes. |
| Accumulate series | This option displays data values in a cumulative frequency. |
| Show legend | This option shows/hides the legend under the chart, indicating the name of the series and its color. |
| Logarithmic axis | This option displays data using a logarithmic scale, useful when there is a large range of quantities. |
Choose Dark or Light to assign a color scheme. Select Apply settings to all to apply this scheme to all your current open charts.
Series
Here you can select the values you want to show/hide in the chart. This does not change the query itself.
Series configuration
You can configure the different series in the chart and create bands using two series in order to measure fluctuations.
Click to show/hide vertical stripes indicating where the series have values higher than 0.
Select two series in the left area and click Create band to add a new band. You can create several bands, assign them different colors and rename them.
Exporting a chart aggregation to a dashboard
You can export a chart aggregation created in a data table to a dashboard clicking this icon:
Fill the required information and click Export to send the chart to a dashboard. Click here to learn more about Devo dashboards.
The window contains the following fields:
Datasource | Name | Enter a name for the data source. |
|---|---|---|
| Description | Enter a description for the data source. | |
| Tags | Enter tags that help categorize the data source. | |
| Build From | Enter the date from which you want to start collecting data. | |
| Minimum Aggregation Period | Select how often you want data to be aggregated. Choose between 1 minute, 5 minutes, 1 hour or Auto (default option). | |
| In real time | Check this option if you want data to be sent in real time. If not checked, use the Delay field to specify the maximum acceptable time difference between the current time and the last event displayed. | |
| Dashboards | Name | Open the dropdown list an choose either an existing dashboard or Create New Dashboard. When you create a new dashboard, you must enter a name in the field below. |
| Widget Name | Name | Enter a name for the widget. |