Skip to main content

Data Group

The following describes the historical data group settings specific to the Canary Labs Historian (Read API) connector.

Group Types

image5.png

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

  • Total

  • Raw Average

  • Raw Total

  • Count

  • Standard Deviation Sample

  • Variance Sample

  • Start Value

  • End Value

  • Delta Value

  • Range

  • Duration Good

  • Duration Bad

  • Percent Good

  • Percent Bad

  • Worst Quality

  • Average 2

  • Total 2

  • Minimum 2

  • Maximum 2

  • Time of Minimum 2

  • Time of Maximum 2

  • Duration in state zero

  • Duration in state non zero

  • Start Bound

  • End Bound

  • Delta Bounds

  • Worst Quality 2

  • Standard Deviation Population

  • Variance Population

  • Total Per Minute

  • Total Per Hour

  • Total Per 24 Hours

For details on these aggregates, see the Canary Labs documentation.

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

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