Skip to main content

Data Group

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

Group Types

image34.png

For Proficy Historian the following group types are available:

Summary Values from Server

This group type retrieves summary calculations directly from the historian. For Proficy Historian, the following calculations are available:

  • Average

  • Maximum

  • Minimum

  • Count

  • Total

  • Standard Deviation

  • Interpolated

  • Raw Average

  • Raw Standard Deviation

  • Raw Total

  • Time Good

  • First Raw Value

  • Last Raw Value

  • State Count

  • State Time

Summary Values from XLReporter

This group type 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

This group retrieves values logged to the historian between the start and end time specified.

Sampled Values

This group retrieves lab sample values from the historian between the start, end and interval specified.

Live Values

This group retrieves the last recorded values in the historian for every selected tag.

Custom Values

This option 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 (Summary Values for XLReporter)

image27.png

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 Proficy Historian Sampled Values and Raw Values are available.

  • Sampled Values use the Lab Sample retrieval mode.

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

Time Period Tab (Raw Values)

image28.png

For Raw Values, the Raw Data Retrieval defines the time period for the group. The following options are available:

  • By time

  • Using this option, raw data is retrieved between the Start and End configured.

  • By record forward

  • Using this option, raw data is retrieved from the Start going forward for the number of samples defined in the Interval Count setting. The End is ignored.

  • By record backward

  • Using this option, raw data is retrieved from the Start going backwards for the number of samples defined in the Interval Count setting. The End is ignored.

Filters Tab

image29.png

All filtering is performed on the Historian server.

In this section: