Retrieve aggregate values

You can retrieve aggregated values for one or more analog tags. Values are calculated using the standard SQL Server aggregation functions.

To retrieve aggregated values from the AVEVA Historian’s summary tables, see Retrieving Values for Summarized Tags.

To retrieve aggregate values:

1. In cells in your worksheet, enter one or more tagnames (one tagname per cell).

2. On the Historian tab, in the Tag Management group, click Tag Values, and then click Aggregate Values. The Aggregate Values - Step 1 of 4 dialog box appears.

3. In the Servers list, click the name of the server to use.

4. In the Select cell(s) containing tag name(s) list, specify the location of the worksheet cell(s) that contains the tag name(s). Click on the button to select the cell(s). For more information, see Selecting Cells.

5. If you want to use a named tag range variable instead, click Binding Options and then configure the range. For more information, see Use "Binding" tags in a query at run time.

6. Click Next. The Aggregate Values - Step 2 of 4 dialog box appears.

7. In the Select cell for output list, specify the location of the worksheet cell(s) that will contain the output. Click on the button to select the cell(s) using your mouse. For more information, see Selecting Cells.

8. Select the Enter the results as an array-formula check box to insert the results as an array formula. An array formula can perform one or more calculations and then return either single result or multiple results. An array formula allows for the resending of the query, since the query parameters are included in the cells that contain the query results. For more information, see Working with Functions, Formulas, and Cells.

9. Select the Select cells to specify format options check box to specify a range of cells that contain formatting information. The formatting information in the cells will be applied to the query results. For more information, see Selecting Cells.

10. Click Next. The Aggregate Values - Step 3 of 4 dialog box appears.

11. Configure the criteria for the query.

    See Format Tab.

    See Calculations Tab.

    See Resolution Tab.

    See Criteria Tab.

12. Click Next. The Aggregate Values - Step 4 of 4 dialog box appears.

13. Configure the time for the query. For more information on configuring these options, see Time Options for Queries.

14. Click Finish.