Retrieve values for summarized tags

You can retrieve summary values for tags that have been configured to be summarized by the AVEVA Historian event subsystem.

To retrieve summary system 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 Summary System Values. The Summary System 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 Using "Binding" Tags to a Query at Run Time.

6. Click Next. The Summary 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 Summary Values - Step 3 of 4 dialog box appears.

11. Configure the criteria for the query.

    See Display Options Tab and Summary Options Tab.

12. Click Next. The Summary 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.