Skip to main content

Data Group

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

Group Types

image54.png

The following group types are available:

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

  • Average

  • Maximum

  • Time of Maximum

  • Minimum

  • Time of Minimum

  • Count

  • Total

  • Standard Deviation

  • Range

  • Mean

  • Population Standard Deviation

Summary Values from XLReporter retrieves sampled values from the historian and performs calculations on those samples for reporting.

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 values logged to the historian between the start and end time specified.

Sampled Values retrieves sampled values from the historian between the start and end time specified at the interval specified.

Live Values retrieves the last recorded values in the historian for every selected tag.

Custom Values opens the Database Group builder where a query can be configured to retrieve data from any table available in the historian database.

Group Settings

Setup Tab

image55.png

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

  • Rate defines the interval (in seconds) that sampled values are retrieved from the historian.

  • Lead Time defines the amount of time (in seconds) to retrieve data before the start time.

Filters Tab (Summary Values from Server)

Calculation Basis determines how the server calculations are performed. See PI documentation for details on what each one means.

Filters Tab (Summary Values from XLR, Raw Values, Sampled Values)

image56.png

Status can be used to filter the status (or quality) of the values returned. All Tag Values means that every value is returned regardless of status where Only Good Quality means that values where status is good will be returned by the group.

In this section: