Skip to main content

Data Group

The following describes the historical data group settings specific to the VTScada Historian connector.

Group Types

image13.png

For VTScada Historian the following group types are available:

Summary Values from Server retrieves summary calculations directly from the historian. The following calculations are available:

  • Interpolated

  • Average

  • Maximum

  • Time of Maximum

  • Minimum

  • Time of Minimum

  • Delta Value

  • Start Value

  • Total

  • Zero to Non-Zero Count

  • Non-Zero Time

For string values, select Start Value.

Summary Values from XLReporter retrieves sampled values from the historian 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.

Note

String values cannot be returned from VTScada using a Summary Values XLR group type.

Raw Values retrieves values logged to the historian 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 available in the database connected to by the connector.

Group Settings

Setup Tab

image14.png

For Summary Values for XLReporter groups, the Retrieval settings define how data is retrieved for the calculations selected for the group. The following settings are available:

  • Retrieval Mode

    This setting defines how data is retrieved from the historian. For VTScada Historian Sampled Values and Raw Values are available.

    Sampled Values use the Interpolated calculation.

  • Rate

    The interval (in seconds) that sampled values are retrieved from the historian.

  • Lead Time

    The amount of time (in seconds) to retrieve data before the start time.

Filters Tab

For Raw Values and Summary Values from XLReporter groups, 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.

In this section: