Query Type: Aggregate Values

You can view aggregated values for specified tags. Aggregations supported are count, minimum, maximum, sum, average, and standard deviation. Aggregations are calculated using the standard SQL Server aggregation functions. To retrieve aggregated values from the AVEVA Historian’s summary tables, use the Summary Values query type. For more information, see Query Type: Summary Values.

To view aggregate values

1. In the Query Type list in the toolbar, click Aggregate values.

2. Use the Tag Picker to select one or more tags.

3. In the Columns pane, click on each tab and configure the parameters for the query.

   • See Format Tab.

   • See Time Tab.

   • See Criteria Tab.

   • See Calculations Tab.

   • See Retrieval Tab.

   • See Source Tab.

4. To view the results, click the Data tab in the Results pane.