Data Group
The following describes the historical data group settings specific to the OPC UA HA Historical Values connector.
The following Group Types are available:
Summary Values from Server retrieves summary calculations directly from the historian.
Summary Values from XLReporter retrieves sampled values from the historian and performs calculations on those samples for reporting.
Raw Values retrieves values logged to the historian between the start and end time specified.
Note
By default, summary values are time-weighted Calculations 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.
Group Settings
For Summary Values from XLReporter groups, the Retrieval settings on the Setup Tab define how data is retrieved for the calculations selected for the group. The following ettings 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. If the OPC UA HA server does not support the Interpolated calculation, do not use Sampled Values.
Rate is 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.
Server Calcuations
The following calculations are presented when a Summary Values from Server data group is configured. Please consult the documentation on your specific OPC UA HA server to see which calculations are supported.
Interpolated | The calculated value at the beginning of the interval based on data points before and after the timestamp. |
Average | The time weighted average over the interval using interpolated bounding values. |
Average 2 | The time weighted average over the interval using simple bounding values. |
Maximum | The maximum raw value in the interval. |
Maximum 2 | The maximum value in the interval including the simple bounding values. |
Time of Maximum | The timestamp of the maximum raw value in the interval. |
Time of Maximum 2 | The timestamp of the maximum value in the interval including the simple bounding values. |
Minimum | The minimum raw value in the interval. |
Minimum 2 | The minimum value in the interval including the simple bounding values. |
Time of Minimum | The timestamp of the minimum raw value in the interval. |
Time of Minimum 2 | The timestamp of the minimum raw value in the interval. |
Range | The difference between the maximum and minimum values in the interval. |
Range 2 | The difference between the maximum 2 and minimum 2 values in the interval. |
Standard Deviation Sample | The standard deviation for the interval for a sample of the population (n-1) |
Standard Deviation Population | The standard deviation for the interval for the entire population (n) including the simple bounding values. |
Variance Sample | The variance for the interval as calculated by the standard deviation sample. |
Variance Population | The variance for the interval as calculated by the standard deviation population. |
Total | The total (time integral) for the interval including interpolated bounding values. |
Total 2 | The total (time integral) for the interval including simple bounding values. |
Count | The number of raw values for the interval. |
Average (raw) | The average value for the interval (sum of raw values divided by count of raw values). |
Start Value | The first raw value for the interval. |
End Value | The last raw value for the interval. |
Delta Value | The difference between the start and end values of the interval. |
Stard Bound | The value at the beginning of the interval using simple bounding values. |
End Bound | The value at the end of the interval using simple bounding values. |
Delta Bound | The difference between the start and end bound values of the interval. |
Annotation Count | The number of annotations in the interval. |
Duration Good | The total time in the interval during which data is good quality. |
Duration Bad | The total time in the interval during which data is bad quality. |
Percentage Good | The percentage of time in the interval (0-100) during which data is good quality. |
Percentage Bad | The percentage of time in the interval (0-100) during which data is bad quality. |
Worst Quality | The worst status code of data in the interval. |
Worst Quality 2 | The worst status code of data in the interval including simple bounding values. |
Duration in State Zero | The worst status code of data in the interval including simple bounding values. |
Duration in State Non Zero | The time a boolean or numeric value was in a zero state during the interval including simple bounding |
Number of Transactions | The number of changes between a zero and non zero state for a boolean or numeric value during the interval. |
Bounding Values |
|