Skip to main content

Data Group

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

Group Types

image65.png

For PI 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

  • Range

  • Standard Deviation

  • Total

  • Count

  • Raw Average

  • Start Value

  • End Value

  • Delta Value

  • Percent Good

  • Percent Bad

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.

Group Settings

Setup Tab

image10.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 where Sampled Values uses the Interpolated calculation.

  • 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.

In this section: