Data Group
The following describes the historical data group settings specific to the AVEVA Edge Historical Values connector.
Group Types
The following group types are available:
Summary Values from XLReporter retrieves sampled values from the database and performs calculations on those samples for reporting.
Note
By default, summary values are calculated time weighted, and values are propagated based on the last known value. However, to change this so that summary values are calculated strictly on the data returned check use raw values.
Raw Values retrieves every value logged to the database between the start and end time specified.
Custom Values opens the Database Group builder where a query can be configured to retrieve data from any table in the database.
Group Settings
Setup Tab
The Retrieval settings define how data is retrieved for the calculations selected for the group. The following settings are available:
Retrieval Mode defines how data is retrieved from the historian. Raw Values are available.
Lead Time defines the amount of time (in seconds) to retrieve data before the start time.
Filters Tab
If the Perform by Server option is checked, any filter configured in this tab is put into the WHERE clause of the query sent to the database to retrieve data for the group. Otherwise, the configured filtering is performed by the reporting engine after the values are returned. It is recommended to leave this setting checked as the performance is much better.