Errata exists for this version of the document.
For the purposes of Historian 1 examples consider a source historian with the following data:
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00 |
- |
Bad_NoData |
First archive entry, Point created |
|
12:00:10 |
10 |
Raw, Good |
|
|
12:00:20 |
20 |
Raw, Good |
|
|
12:00:30 |
30 |
Raw, Good |
|
|
12:00:40 |
40 |
Raw, Bad |
|
|
12:00:50 |
50 |
Raw, Good |
|
|
12:01:00 |
60 |
Raw, Good |
|
|
12:01:10 |
70 |
Raw, Uncertain |
|
|
12:01:20 |
80 |
Raw, Good |
|
|
12:01:30 |
90 |
Raw, Good |
|
|
|
null |
No Data |
No more entries, awaiting next scan |
The example historian also has Annotations associated with three data points.
Figure 6 – Example Data for Historian 1
For the purposes of all Historian 1 examples:
- TreatUncertainAsBad = False. Therefore Uncertain values are included in Aggregate calls.
- Stepped Attribute = False. Therefore SlopedInterpolation is used between data points.
- UseSlopedExtrapolation = False. Therefore SteppedExtrapolation is used at end boundary conditions.
- PercentBad = 100, PercentGood = 100. Therefore if all values are Good then the quality will be Good, or if all values are Bad then the quality will be Bad, but if there is some Good and some Bad then the quality will be Uncertain.
This example is included to illustrate non-periodic data. For the purposes of Historian 2 examples consider a source historian with the following data:
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00 |
- |
Bad_NoData |
First archive entry, Point created |
|
12:00:02 |
10 |
Raw, Good |
|
|
12:00:25 |
20 |
Raw, Good |
|
|
12:00:28 |
25 |
Raw, Good |
|
|
12:00:39 |
30 |
Raw, Good |
|
|
12:00:42 |
- |
Raw, Bad |
Bad quality data received, Bad data entered |
|
12:00:48 |
40 |
Raw, Good |
Received Good StatusCode value |
|
12:00:52 |
50 |
Raw, Good |
|
|
12:01:12 |
60 |
Raw, Good |
|
|
12:01:17 |
70 |
Raw, Uncertain |
Value is flagged as questionable |
|
12:01:23 |
70 |
Raw, Good |
|
|
12:01:26 |
80 |
Raw, Good |
|
|
12:01:30 |
90 |
Raw, Good |
|
|
|
- |
No Data |
No more entries, awaiting next Value |
Figure 7 – Example Data for Historian 2
For the purposes of all Historian 2 examples:
- TreatUncertainAsBad = True. Therefore Uncertain values are treated as Bad, and not included in the Aggregate call.
- Stepped Attribute = False. Therefore SlopedInterpolation is used between data points.
- UseSlopedExtrapolation = False. Therefore SteppedExtrapolation is used at end boundary conditions.
- PercentBad = 100, PercentGood = 100. Therefore unless if all values are Good then the quality will be Good, or if all values are Bad then the quality will be Bad, but if there is some Good and some Bad then the quality will be Uncertain.
This example is included to illustrate stepped data. For the purposes of Historian 3 examples consider a source historian with the following data:
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00 |
- |
Bad_NoData |
First archive entry, Point created |
|
12:00:02 |
10 |
Raw, Good |
|
|
12:00:25 |
20 |
Raw, Good |
|
|
12:00:28 |
25 |
Raw, Good |
|
|
12:00:39 |
30 |
Raw, Good |
|
|
12:00:42 |
- |
Raw, Bad |
Bad quality data received, Bad data entered |
|
12:00:48 |
40 |
Raw, Good |
Received Good StatusCode value |
|
12:00:52 |
50 |
Raw, Good |
|
|
12:01:12 |
60 |
Raw, Good |
|
|
12:01:17 |
70 |
Raw, Uncertain |
Value is flagged as questionable |
|
12:01:23 |
70 |
Raw, Good |
|
|
12:01:26 |
80 |
Raw, Good |
|
|
12:01:30 |
90 |
Raw, Good |
|
|
|
- |
No Data |
No more entries, awaiting next Value |
Figure 8 – Example Data for Historian 3
For the purposes of all Historian 3 examples:
- TreatUncertainAsBad = True. Therefore Uncertain values are treated as Bad, and not included in the Aggregate call.
- Stepped Attribute = True. Therefore SteppedInterpolation is used between data points.
- UseSlopedExtrapolation = False. Therefore SteppedExtrapolation is used at end boundary conditions.
- PercentBad = 50, PercentGood = 50. Therefore data will be either Good or Bad quality. Uncertain should not happen since a value is either Good or Bad.
This example is included to illustrate Boolean data. For the purposes of Historian 4 examples consider a source historian with the following data:
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00 |
- |
Bad_NoData |
First archive entry, Point created |
|
12:00:02 |
TRUE |
Raw, Good |
|
|
12:00:25 |
FALSE |
Raw, Good |
|
|
12:00:28 |
TRUE |
Raw, Good |
|
|
12:00:39 |
TRUE |
Raw, Good |
|
|
12:00:42 |
- |
Raw, Bad |
Bad quality data received, Bad data entered |
|
12:00:48 |
TRUE |
Raw, Good |
Received Good StatusCode value |
|
12:00:52 |
FALSE |
Raw, Good |
|
|
12:01:12 |
FALSE |
Raw, Good |
|
|
12:01:17 |
TRUE |
Raw, Uncertain |
Value is flagged as questionable |
|
12:01:23 |
TRUE |
Raw, Good |
|
|
12:01:26 |
FALSE |
Raw, Good |
|
|
12:01:30 |
TRUE |
Raw, Good |
|
|
|
- |
No Data |
No more entries, awaiting next Value |
For the purposes of all Historian 4 examples:
- TreatUncertainAsBad = True. Therefore Uncertain values are treated as Bad, and not included in the Aggregate call.
- Stepped Attribute = True. Therefore SteppedInterpolation is used between data points.
- UseSlopedExtrapolation = False. Therefore SteppedExtrapolation is used at end boundary conditions.
- PercentGood = 100, PercentBad = 100.
For Boolean data interpolation and extrapolation shall always be stepped.
The following examples demonstrate Interpolative Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:05, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData |
|
|
12:00:05.000 |
|
BadNoData |
|
|
12:00:10.000 |
10 |
Good |
|
|
12:00:15.000 |
15 |
Good, Interpolated |
|
|
12:00:20.000 |
20 |
Good |
|
|
12:00:25.000 |
25 |
Good, Interpolated |
|
|
12:00:30.000 |
30 |
Good |
|
|
12:00:35.000 |
35 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:40.000 |
40 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:45.000 |
45 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:50.000 |
50 |
Good |
|
|
12:00:55.000 |
55 |
Good, Interpolated |
|
|
12:01:00.000 |
60 |
Good |
|
|
12:01:05.000 |
65 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:10.000 |
70 |
Uncertain |
|
|
12:01:15.000 |
75 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:20.000 |
80 |
Good |
|
|
12:01:25.000 |
85 |
Good, Interpolated |
|
|
12:01:30.000 |
90 |
Good |
|
|
12:01:35.000 |
90 |
UncertainDataSubNormal, Interpolated |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData |
|
|
12:00:05.000 |
11.304 |
Good, Interpolated |
|
|
12:00:10.000 |
13.478 |
Good, Interpolated |
|
|
12:00:15.000 |
15.652 |
Good, Interpolated |
|
|
12:00:20.000 |
17.826 |
Good, Interpolated |
|
|
12:00:25.000 |
20 |
Good |
|
|
12:00:30.000 |
25.909 |
Good, Interpolated |
|
|
12:00:35.000 |
28.182 |
Good, Interpolated |
|
|
12:00:40.000 |
31.111 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:45.000 |
36.667 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:50.000 |
45 |
Good, Interpolated |
|
|
12:00:55.000 |
51.500 |
Good, Interpolated |
|
|
12:01:00.000 |
54 |
Good, Interpolated |
|
|
12:01:05.000 |
56.500 |
Good, Interpolated |
|
|
12:01:10.000 |
59 |
Good, Interpolated |
|
|
12:01:15.000 |
62.727 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:20.000 |
67.273 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:25.000 |
76.667 |
Good, Interpolated |
|
|
12:01:30.000 |
90 |
Good |
|
|
12:01:35.000 |
90 |
UncertainDataSubNormal, Interpolated |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData |
|
|
12:00:05.000 |
10 |
Good, Interpolated |
|
|
12:00:10.000 |
10 |
Good, Interpolated |
|
|
12:00:15.000 |
10 |
Good, Interpolated |
|
|
12:00:20.000 |
10 |
Good, Interpolated |
|
|
12:00:25.000 |
20 |
Good |
|
|
12:00:30.000 |
25 |
Good, Interpolated |
|
|
12:00:35.000 |
25 |
Good, Interpolated |
|
|
12:00:40.000 |
30 |
Good, Interpolated |
|
|
12:00:45.000 |
30 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:50.000 |
40 |
Good, Interpolated |
|
|
12:00:55.000 |
50 |
Good, Interpolated |
|
|
12:01:00.000 |
50 |
Good, Interpolated |
|
|
12:01:05.000 |
50 |
Good, Interpolated |
|
|
12:01:10.000 |
50 |
Good, Interpolated |
|
|
12:01:15.000 |
60 |
Good, Interpolated |
|
|
12:01:20.000 |
60 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:25.000 |
70 |
Good, Interpolated |
|
|
12:01:30.000 |
90 |
Good |
|
|
12:01:35.000 |
90 |
UncertainDataSubNormal, Interpolated |
|
The following examples demonstrate Average Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:05, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData |
|
|
12:00:05.000 |
|
BadNoData |
|
|
12:00:10.000 |
10 |
Good, Calculated |
|
|
12:00:15.000 |
|
BadNoData |
|
|
12:00:20.000 |
20 |
Good, Calculated |
|
|
12:00:25.000 |
|
BadNoData |
|
|
12:00:30.000 |
30 |
Good, Calculated |
|
|
12:00:35.000 |
|
BadNoData |
|
|
12:00:40.000 |
|
BadNoData |
|
|
12:00:45.000 |
|
BadNoData |
|
|
12:00:50.000 |
50 |
Good, Calculated |
|
|
12:00:55.000 |
|
BadNoData |
|
|
12:01:00.000 |
60 |
Good, Calculated |
|
|
12:01:05.000 |
|
BadNoData |
|
|
12:01:10.000 |
|
BadNoData |
|
|
12:01:15.000 |
|
BadNoData |
|
|
12:01:20.000 |
80 |
Good, Calculated |
|
|
12:01:25.000 |
|
BadNoData |
|
|
12:01:30.000 |
90 |
Good, Calculated |
|
|
12:01:35.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated |
|
|
12:00:05.000 |
|
BadNoData |
|
|
12:00:10.000 |
|
BadNoData |
|
|
12:00:15.000 |
|
BadNoData |
|
|
12:00:20.000 |
|
BadNoData |
|
|
12:00:25.000 |
22.500 |
Good, Calculated |
|
|
12:00:30.000 |
|
BadNoData |
|
|
12:00:35.000 |
30 |
Good, Calculated |
|
|
12:00:40.000 |
|
BadNoData |
|
|
12:00:45.000 |
40 |
Good, Calculated |
|
|
12:00:50.000 |
50 |
Good, Calculated |
|
|
12:00:55.000 |
|
BadNoData |
|
|
12:01:00.000 |
|
BadNoData |
|
|
12:01:05.000 |
|
BadNoData |
|
|
12:01:10.000 |
60 |
Good, Calculated |
|
|
12:01:15.000 |
|
BadNoData |
|
|
12:01:20.000 |
70 |
Good, Calculated |
|
|
12:01:25.000 |
80 |
Good, Calculated |
|
|
12:01:30.000 |
90 |
Good, Calculated |
|
|
12:01:35.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated |
|
|
12:00:05.000 |
|
BadNoData |
|
|
12:00:10.000 |
|
BadNoData |
|
|
12:00:15.000 |
|
BadNoData |
|
|
12:00:20.000 |
|
BadNoData |
|
|
12:00:25.000 |
22.500 |
Good, Calculated |
|
|
12:00:30.000 |
|
BadNoData |
|
|
12:00:35.000 |
30 |
Good, Calculated |
|
|
12:00:40.000 |
|
BadNoData |
|
|
12:00:45.000 |
40 |
Good, Calculated |
|
|
12:00:50.000 |
50 |
Good, Calculated |
|
|
12:00:55.000 |
|
BadNoData |
|
|
12:01:00.000 |
|
BadNoData |
|
|
12:01:05.000 |
|
BadNoData |
|
|
12:01:10.000 |
60 |
Good, Calculated |
|
|
12:01:15.000 |
|
BadNoData |
|
|
12:01:20.000 |
70 |
Good, Calculated |
|
|
12:01:25.000 |
80 |
Good, Calculated |
|
|
12:01:30.000 |
90 |
Good, Calculated |
|
|
12:01:35.000 |
|
BadNoData |
|
The following examples demonstrate TimeAverage Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:05, StartTime: 12:00:00, EndTime: 12:01:40
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData |
|
|
12:00:05.000 |
|
BadNoData |
|
|
12:00:10.000 |
12.500 |
Good, Calculated |
|
|
12:00:15.000 |
17.500 |
Good, Calculated |
|
|
12:00:20.000 |
22.500 |
Good, Calculated |
|
|
12:00:25.000 |
27.500 |
Good, Calculated |
|
|
12:00:30.000 |
32.500 |
UncertainDataSubNormal, Calculated |
|
|
12:00:35.000 |
37.500 |
UncertainDataSubNormal, Calculated |
|
|
12:00:40.000 |
42.500 |
UncertainDataSubNormal, Calculated |
|
|
12:00:45.000 |
47.500 |
UncertainDataSubNormal, Calculated |
|
|
12:00:50.000 |
52.500 |
Good, Calculated |
|
|
12:00:55.000 |
57.500 |
Good, Calculated |
|
|
12:01:00.000 |
62.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:05.000 |
67.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:10.000 |
72.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:15.000 |
77.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
82.500 |
Good, Calculated |
|
|
12:01:25.000 |
87.500 |
Good, Calculated |
|
|
12:01:30.000 |
90 |
UncertainDataSubNormal, Calculated |
|
|
12:01:35.000 |
90 |
UncertainDataSubNormal, Calculated |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10.652 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:05.000 |
12.391 |
Good, Calculated |
|
|
12:00:10.000 |
14.565 |
Good, Calculated |
|
|
12:00:15.000 |
16.739 |
Good, Calculated |
|
|
12:00:20.000 |
18.913 |
Good, Calculated |
|
|
12:00:25.000 |
23.682 |
Good, Calculated |
|
|
12:00:30.000 |
27.046 |
Good, Calculated |
|
|
12:00:35.000 |
29.384 |
UncertainDataSubNormal, Calculated |
|
|
12:00:40.000 |
33.889 |
UncertainDataSubNormal, Calculated |
|
|
12:00:45.000 |
40 |
UncertainDataSubNormal, Calculated |
|
|
12:00:50.000 |
49.450 |
Good, Calculated |
|
|
12:00:55.000 |
52.750 |
Good, Calculated |
|
|
12:01:00.000 |
55.250 |
Good, Calculated |
|
|
12:01:05.000 |
57.750 |
Good, Calculated |
|
|
12:01:10.000 |
60.618 |
UncertainDataSubNormal, Calculated |
|
|
12:01:15.000 |
65 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
70.515 |
UncertainDataSubNormal, Calculated |
|
|
12:01:25.000 |
83.667 |
Good, Calculated |
|
|
12:01:30.000 |
90 |
UncertainDataSubNormal, Calculated |
|
|
12:01:35.000 |
90 |
UncertainDataSubNormal, Calculated |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10.652 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:05.000 |
12.391 |
Good, Calculated |
|
|
12:00:10.000 |
14.565 |
Good, Calculated |
|
|
12:00:15.000 |
16.739 |
Good, Calculated |
|
|
12:00:20.000 |
18.913 |
Good, Calculated |
|
|
12:00:25.000 |
23.682 |
Good, Calculated |
|
|
12:00:30.000 |
27.046 |
Good, Calculated |
|
|
12:00:35.000 |
29.384 |
UncertainDataSubNormal, Calculated |
|
|
12:00:40.000 |
33.889 |
UncertainDataSubNormal, Calculated |
|
|
12:00:45.000 |
40 |
UncertainDataSubNormal, Calculated |
|
|
12:00:50.000 |
49.450 |
Good, Calculated |
|
|
12:00:55.000 |
52.750 |
Good, Calculated |
|
|
12:01:00.000 |
55.250 |
Good, Calculated |
|
|
12:01:05.000 |
57.750 |
Good, Calculated |
|
|
12:01:10.000 |
60.618 |
UncertainDataSubNormal, Calculated |
|
|
12:01:15.000 |
65 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
70.515 |
UncertainDataSubNormal, Calculated |
|
|
12:01:25.000 |
83.667 |
Good, Calculated |
|
|
12:01:30.000 |
90 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:35.000 |
90 |
UncertainDataSubNormal, Calculated |
|
The following examples demonstrate TimeAverage2 Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:05, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData |
|
|
12:00:05.000 |
|
BadNoData |
|
|
12:00:10.000 |
12.500 |
Good, Calculated |
|
|
12:00:15.000 |
17.500 |
Good, Calculated |
|
|
12:00:20.000 |
22.500 |
Good, Calculated |
|
|
12:00:25.000 |
27.500 |
Good, Calculated |
|
|
12:00:30.000 |
30 |
UncertainDataSubNormal, Calculated |
|
|
12:00:35.000 |
30 |
UncertainDataSubNormal, Calculated |
|
|
12:00:40.000 |
|
BadNoData |
|
|
12:00:45.000 |
|
BadNoData |
|
|
12:00:50.000 |
52.500 |
Good, Calculated |
|
|
12:00:55.000 |
57.500 |
Good, Calculated |
|
|
12:01:00.000 |
62.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:05.000 |
67.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:10.000 |
72.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:15.000 |
77.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
82.500 |
Good, Calculated |
|
|
12:01:25.000 |
87.500 |
Good, Calculated |
|
|
12:01:30.000 |
90 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:35.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10.652 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:05.000 |
12.391 |
Good, Calculated |
|
|
12:00:10.000 |
14.565 |
Good, Calculated |
|
|
12:00:15.000 |
16.739 |
Good, Calculated |
|
|
12:00:20.000 |
18.913 |
Good, Calculated |
|
|
12:00:25.000 |
23.682 |
Good, Calculated |
|
|
12:00:30.000 |
27.046 |
Good, Calculated |
|
|
12:00:35.000 |
29.273 |
UncertainDataSubNormal, Calculated |
|
|
12:00:40.000 |
30 |
UncertainDataSubNormal, Calculated |
|
|
12:00:45.000 |
42.500 |
UncertainDataSubNormal, Calculated |
|
|
12:00:50.000 |
49.450 |
Good, Calculated |
|
|
12:00:55.000 |
52.750 |
Good, Calculated |
|
|
12:01:00.000 |
55.250 |
Good, Calculated |
|
|
12:01:05.000 |
57.750 |
Good, Calculated |
|
|
12:01:10.000 |
59.800 |
UncertainDataSubNormal, Calculated |
|
|
12:01:15.000 |
60 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
73.333 |
UncertainDataSubNormal, Calculated |
|
|
12:01:25.000 |
83.667 |
Good, Calculated |
|
|
12:01:30.000 |
90 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:35.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:05.000 |
10 |
Good, Calculated |
|
|
12:00:10.000 |
10 |
Good, Calculated |
|
|
12:00:15.000 |
10 |
Good, Calculated |
|
|
12:00:20.000 |
10 |
Good, Calculated |
|
|
12:00:25.000 |
22 |
Good, Calculated |
|
|
12:00:30.000 |
25 |
Good, Calculated |
|
|
12:00:35.000 |
26 |
Good, Calculated |
|
|
12:00:40.000 |
|
Bad, Calculated |
|
|
12:00:45.000 |
|
Bad, Calculated |
|
|
12:00:50.000 |
46 |
Good, Calculated |
|
|
12:00:55.000 |
50 |
Good, Calculated |
|
|
12:01:00.000 |
50 |
Good, Calculated |
|
|
12:01:05.000 |
50 |
Good, Calculated |
|
|
12:01:10.000 |
56 |
Good, Calculated |
|
|
12:01:15.000 |
|
Bad, Calculated |
|
|
12:01:20.000 |
|
Bad, Calculated |
|
|
12:01:25.000 |
78 |
Good, Calculated |
|
|
12:01:30.000 |
90 |
Good, Calculated, Partial |
|
|
12:01:35.000 |
|
BadNoData |
|
The following examples demonstrate Total Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:05, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData |
|
|
12:00:05.000 |
|
BadNoData |
|
|
12:00:10.000 |
62.500 |
Good, Calculated |
|
|
12:00:15.000 |
87.500 |
Good, Calculated |
|
|
12:00:20.000 |
112.500 |
Good, Calculated |
|
|
12:00:25.000 |
137.500 |
Good, Calculated |
|
|
12:00:30.000 |
162.500 |
UncertainDataSubNormal, Calculated |
|
|
12:00:35.000 |
187.500 |
UncertainDataSubNormal, Calculated |
|
|
12:00:40.000 |
212.500 |
UncertainDataSubNormal, Calculated |
|
|
12:00:45.000 |
237.500 |
UncertainDataSubNormal, Calculated |
|
|
12:00:50.000 |
262.500 |
Good, Calculated |
|
|
12:00:55.000 |
287.500 |
Good, Calculated |
|
|
12:01:00.000 |
312.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:05.000 |
337.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:10.000 |
362.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:15.000 |
387.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
412.500 |
Good, Calculated |
|
|
12:01:25.000 |
437.500 |
Good, Calculated |
|
|
12:01:30.000 |
450 |
UncertainDataSubNormal, Calculated |
|
|
12:01:35.000 |
450 |
UncertainDataSubNormal, Calculated |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
31.957 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:05.000 |
61.957 |
Good, Calculated |
|
|
12:00:10.000 |
72.826 |
Good, Calculated |
|
|
12:00:15.000 |
83.696 |
Good, Calculated |
|
|
12:00:20.000 |
94.565 |
Good, Calculated |
|
|
12:00:25.000 |
118.409 |
Good, Calculated |
|
|
12:00:30.000 |
135.227 |
Good, Calculated |
|
|
12:00:35.000 |
146.919 |
UncertainDataSubNormal, Calculated |
|
|
12:00:40.000 |
169.444 |
UncertainDataSubNormal, Calculated |
|
|
12:00:45.000 |
200 |
UncertainDataSubNormal, Calculated |
|
|
12:00:50.000 |
247.250 |
Good, Calculated |
|
|
12:00:55.000 |
263.750 |
Good, Calculated |
|
|
12:01:00.000 |
276.250 |
Good, Calculated |
|
|
12:01:05.000 |
288.750 |
Good, Calculated |
|
|
12:01:10.000 |
303.091 |
UncertainDataSubNormal, Calculated |
|
|
12:01:15.000 |
325 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
352.576 |
UncertainDataSubNormal, Calculated |
|
|
12:01:25.000 |
418.333 |
Good, Calculated |
|
|
12:01:30.000 |
481.250 |
UncertainDataSubNormal, Calculated |
|
|
12:01:35.000 |
543.750 |
UncertainDataSubNormal, Calculated |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
30 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:05.000 |
50 |
Good, Calculated |
|
|
12:00:10.000 |
50 |
Good, Calculated |
|
|
12:00:15.000 |
50 |
Good, Calculated |
|
|
12:00:20.000 |
50 |
Good, Calculated |
|
|
12:00:25.000 |
110 |
Good, Calculated |
|
|
12:00:30.000 |
125 |
Good, Calculated |
|
|
12:00:35.000 |
130 |
Good, Calculated |
|
|
12:00:40.000 |
150 |
UncertainDataSubNormal, Calculated |
|
|
12:00:45.000 |
170 |
UncertainDataSubNormal, Calculated |
|
|
12:00:50.000 |
230 |
Good, Calculated |
|
|
12:00:55.000 |
250 |
Good, Calculated |
|
|
12:01:00.000 |
250 |
Good, Calculated |
|
|
12:01:05.000 |
250 |
Good, Calculated |
|
|
12:01:10.000 |
280 |
Good, Calculated |
|
|
12:01:15.000 |
300 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
320 |
UncertainDataSubNormal, Calculated |
|
|
12:01:25.000 |
390 |
Good, Calculated |
|
|
12:01:30.000 |
450 |
UncertainDataSubNormal, Calculated |
|
|
12:01:35.000 |
450 |
UncertainDataSubNormal, Calculated |
|
The following examples demonstrate Total2 Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:05, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData |
|
|
12:00:05.000 |
|
BadNoData |
|
|
12:00:10.000 |
62.500 |
Good, Calculated |
|
|
12:00:15.000 |
87.500 |
Good, Calculated |
|
|
12:00:20.000 |
112.500 |
Good, Calculated |
|
|
12:00:25.000 |
137.500 |
Good, Calculated |
|
|
12:00:30.000 |
150 |
UncertainDataSubNormal, Calculated |
|
|
12:00:35.000 |
150 |
UncertainDataSubNormal, Calculated |
|
|
12:00:40.000 |
|
BadNoData |
|
|
12:00:45.000 |
|
BadNoData |
|
|
12:00:50.000 |
262.500 |
Good, Calculated |
|
|
12:00:55.000 |
287.500 |
Good, Calculated |
|
|
12:01:00.000 |
312.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:05.000 |
337.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:10.000 |
362.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:15.000 |
387.500 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
412.500 |
Good, Calculated |
|
|
12:01:25.000 |
437.500 |
Good, Calculated |
|
|
12:01:30.000 |
0.090 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:35.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
31.957 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:05.000 |
61.957 |
Good, Calculated |
|
|
12:00:10.000 |
72.826 |
Good, Calculated |
|
|
12:00:15.000 |
83.696 |
Good, Calculated |
|
|
12:00:20.000 |
94.565 |
Good, Calculated |
|
|
12:00:25.000 |
118.409 |
Good, Calculated |
|
|
12:00:30.000 |
135.227 |
Good, Calculated |
|
|
12:00:35.000 |
146.364 |
UncertainDataSubNormal, Calculated |
|
|
12:00:40.000 |
60 |
UncertainDataSubNormal, Calculated |
|
|
12:00:45.000 |
85 |
UncertainDataSubNormal, Calculated |
|
|
12:00:50.000 |
247.250 |
Good, Calculated |
|
|
12:00:55.000 |
263.750 |
Good, Calculated |
|
|
12:01:00.000 |
276.250 |
Good, Calculated |
|
|
12:01:05.000 |
288.750 |
Good, Calculated |
|
|
12:01:10.000 |
299 |
UncertainDataSubNormal, Calculated |
|
|
12:01:15.000 |
120 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
146.667 |
UncertainDataSubNormal, Calculated |
|
|
12:01:25.000 |
418.333 |
Good, Calculated |
|
|
12:01:30.000 |
0.090 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:35.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
30 |
Good, Calculated, Partial |
|
|
12:00:05.000 |
50 |
Good, Calculated |
|
|
12:00:10.000 |
50 |
Good, Calculated |
|
|
12:00:15.000 |
50 |
Good, Calculated |
|
|
12:00:20.000 |
50 |
Good, Calculated |
|
|
12:00:25.000 |
110 |
Good, Calculated |
|
|
12:00:30.000 |
125 |
Good, Calculated |
|
|
12:00:35.000 |
130 |
Good, Calculated |
|
|
12:00:40.000 |
|
Bad, Calculated |
|
|
12:00:45.000 |
|
Bad, Calculated |
|
|
12:00:50.000 |
230 |
Good, Calculated |
|
|
12:00:55.000 |
250 |
Good, Calculated |
|
|
12:01:00.000 |
250 |
Good, Calculated |
|
|
12:01:05.000 |
250 |
Good, Calculated |
|
|
12:01:10.000 |
280 |
Good, Calculated |
|
|
12:01:15.000 |
|
Bad, Calculated |
|
|
12:01:20.000 |
|
Bad, Calculated |
|
|
12:01:25.000 |
390 |
Good, Calculated |
|
|
12:01:30.000 |
0.090 |
Good, Calculated, Partial |
|
|
12:01:35.000 |
|
BadNoData |
|
The following examples demonstrate Minimum Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
20 |
Good, Calculated |
|
|
12:00:32.000 |
|
BadNoData |
|
|
12:00:48.000 |
50 |
Good, Calculated |
|
|
12:01:04.000 |
|
BadNoData |
|
|
12:01:20.000 |
80 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
20 |
Good, Calculated |
|
|
12:00:32.000 |
30 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:04.000 |
60 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
70 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
20 |
Good, Calculated |
|
|
12:00:32.000 |
30 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:04.000 |
60 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
70 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate Maximum Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
30 |
Good, Calculated |
|
|
12:00:32.000 |
|
BadNoData |
|
|
12:00:48.000 |
60 |
Good, Calculated |
|
|
12:01:04.000 |
|
BadNoData |
|
|
12:01:20.000 |
90 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
25 |
Good, Calculated |
|
|
12:00:32.000 |
30 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
50 |
Good, Calculated |
|
|
12:01:04.000 |
60 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
90 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
25 |
Good, Calculated |
|
|
12:00:32.000 |
30 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
50 |
Good, Calculated |
|
|
12:01:04.000 |
60 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
90 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate the MinimumActualTime Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:10.000 |
10 |
Good, Partial |
|
|
12:00:20.000 |
20 |
Good |
|
|
12:00:32.000 |
|
BadNoData |
|
|
12:00:50.000 |
50 |
Good |
|
|
12:01:04.000 |
|
BadNoData |
|
|
12:01:20.000 |
80 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:25.000 |
20 |
Good |
|
|
12:00:39.000 |
30 |
UncertainDataSubNormal |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:12.000 |
60 |
UncertainDataSubNormal |
|
|
12:01:23.000 |
70 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:25.000 |
20 |
Good |
|
|
12:00:39.000 |
30 |
UncertainDataSubNormal |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:12.000 |
60 |
UncertainDataSubNormal |
|
|
12:01:23.000 |
70 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate MaximumActualTime Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:10.000 |
10 |
Good, Partial |
|
|
12:00:30.000 |
30 |
Good |
|
|
12:00:32.000 |
|
BadNoData |
|
|
12:01:00.000 |
60 |
Good |
|
|
12:01:04.000 |
|
BadNoData |
|
|
12:01:30.000 |
90 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:28.000 |
25 |
Good |
|
|
12:00:39.000 |
30 |
UncertainDataSubNormal |
|
|
12:00:52.000 |
50 |
Good |
|
|
12:01:12.000 |
60 |
UncertainDataSubNormal |
|
|
12:01:30.000 |
90 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:28.000 |
25 |
Good |
|
|
12:00:39.000 |
30 |
UncertainDataSubNormal |
|
|
12:00:52.000 |
50 |
Good |
|
|
12:01:12.000 |
60 |
UncertainDataSubNormal |
|
|
12:01:30.000 |
90 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate Range Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
10 |
Good, Calculated |
|
|
12:00:32.000 |
|
BadNoData |
|
|
12:00:48.000 |
10 |
Good, Calculated |
|
|
12:01:04.000 |
|
BadNoData |
|
|
12:01:20.000 |
10 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
5 |
Good, Calculated |
|
|
12:00:32.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
10 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
20 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
5 |
Good, Calculated |
|
|
12:00:32.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
10 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
20 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate Minimum2 Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:16.000 |
16 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:32.000 |
30 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:48.000 |
50 |
UncertainDataSubNormal, Calculated |
|
|
12:01:04.000 |
64 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:20.000 |
80 |
UncertainDataSubNormal, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:16.000 |
16.087 |
Good, Interpolated |
|
|
12:00:32.000 |
26.818 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:04.000 |
56 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:20.000 |
70 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
10 |
Good, Interpolated |
|
|
12:00:32.000 |
25 |
Good, Interpolated |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:04.000 |
50 |
Good, Interpolated |
|
|
12:01:20.000 |
70 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate Maximum2 Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
16 |
UncertainDataSubNormal, Interpolated, Partial |
|
|
12:00:16.000 |
30 |
UncertainDataSubNormal, Calculated, MultipleValues |
|
|
12:00:32.000 |
30 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:48.000 |
64 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:04.000 |
80 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
90 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
16.087 |
UncertainDataSubNormal, Interpolated, Partial |
|
|
12:00:16.000 |
26.818 |
Good, Interpolated |
|
|
12:00:32.000 |
40 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
56 |
Good, Interpolated |
|
|
12:01:04.000 |
60 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
90 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
25 |
Good, Calculated |
|
|
12:00:32.000 |
30 |
Good, Calculated |
|
|
12:00:48.000 |
50 |
Good, Calculated |
|
|
12:01:04.000 |
60 |
Good, Calculated |
|
|
12:01:20.000 |
90 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate MinimumActualTime2 Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:10.000 |
10 |
UncertainDataSubNormal, Partial |
|
|
12:00:16.000 |
16 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:32.000 |
30 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:50.000 |
50 |
UncertainDataSubNormal |
|
|
12:01:04.000 |
64 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:20.000 |
80 |
UncertainDataSubNormal, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
UncertainDataSubNormal, Partial |
|
|
12:00:16.000 |
16.087 |
Good, Interpolated |
|
|
12:00:32.000 |
26.818 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:04.000 |
56 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:23.000 |
70 |
UncertainDataSubNormal, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:16.000 |
10 |
Good, Interpolated |
|
|
12:00:32.000 |
25 |
Good, Interpolated |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:04.000 |
50 |
Good, Interpolated |
|
|
12:01:23.000 |
70 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate MaximumActualTime2 Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:15.999 |
16 |
UncertainDataSubNormal, Interpolated, Partial |
|
|
12:00:30.000 |
30 |
UncertainDataSubNormal, MultipleValues |
|
|
12:00:32.000 |
30 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:03.999 |
64 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:19.999 |
80 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:30.000 |
90 |
UncertainDataSubNormal, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:15.999 |
16.087 |
UncertainDataSubNormal, Interpolated, Partial |
|
|
12:00:31.999 |
26.818 |
Good, Interpolated |
|
|
12:00:47.999 |
40 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:03.999 |
56 |
Good, Interpolated |
|
|
12:01:12.000 |
60 |
UncertainDataSubNormal |
|
|
12:01:30.000 |
90 |
UncertainDataSubNormal, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:28.000 |
25 |
Good |
|
|
12:00:39.000 |
30 |
Good |
|
|
12:00:52.000 |
50 |
Good |
|
|
12:01:12.000 |
60 |
Good |
|
|
12:01:30.000 |
90 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate Range2 Aggregate scenarios. This Aggregate does not apply to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
6 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:16.000 |
14 |
UncertainDataSubNormal, Calculated |
|
|
12:00:32.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
14 |
UncertainDataSubNormal, Calculated |
|
|
12:01:04.000 |
16 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
10 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
6.087 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:16.000 |
10.731 |
Good, Calculated |
|
|
12:00:32.000 |
13.182 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
16 |
Good, Calculated |
|
|
12:01:04.000 |
4 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
20 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
15 |
Good, Calculated |
|
|
12:00:32.000 |
5 |
Good, Calculated |
|
|
12:00:48.000 |
10 |
Good, Calculated |
|
|
12:01:04.000 |
10 |
Good, Calculated |
|
|
12:01:20.000 |
20 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate AnnotationCount Aggregate scenarios. This Aggregate does not apply to current values, since annotations are features of historical data. ProcessingInterval: 00:01:00, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
3 |
Good, Calculated |
|
|
12:01:00.000 |
1 |
Good, Calculated |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated |
|
|
12:01:00.000 |
0 |
Good, Calculated |
|
The following examples demonstrate Count Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
1 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
2 |
Good, Calculated |
|
|
12:00:32.000 |
|
Bad |
|
|
12:00:48.000 |
2 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
2 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
1 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
2 |
Good, Calculated |
|
|
12:00:32.000 |
1 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
2 |
Good, Calculated |
|
|
12:01:04.000 |
1 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
3 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
1 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
2 |
Good, Calculated |
|
|
12:00:32.000 |
|
Bad |
|
|
12:00:48.000 |
2 |
Good, Calculated |
|
|
12:01:04.000 |
1 |
Good, Calculated |
|
|
12:01:20.000 |
3 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
1 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
2 |
Good, Calculated |
|
|
12:00:32.000 |
1 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
2 |
Good, Calculated |
|
|
12:01:04.000 |
1 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
3 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate DurationInStateZero Aggregate scenarios. The Aggregate only applies to Historian 4. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:16.000 |
3000 |
Good, Calculated |
|
|
12:00:32.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
12000 |
Good, Calculated |
|
|
12:01:04.000 |
13000 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
4000 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate DurationInStateNonZero Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
14000 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:00:16.000 |
13000 |
Good, Calculated |
|
|
12:00:32.000 |
10000 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
4000 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
3001 |
UncertainDataSubNormal, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate NumberOfTransitions Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
1 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
2 |
Good, Calculated |
|
|
12:00:32.000 |
|
Bad |
|
|
12:00:48.000 |
2 |
Good, Calculated |
|
|
12:01:04.000 |
1 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
2 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
1 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
2 |
Good, Calculated |
|
|
12:00:32.000 |
1 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
2 |
Good, Calculated |
|
|
12:01:04.000 |
1 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
3 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
1 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
2 |
Good, Calculated |
|
|
12:00:32.000 |
|
Bad |
|
|
12:00:48.000 |
2 |
Good, Calculated |
|
|
12:01:04.000 |
1 |
Good, Calculated |
|
|
12:01:20.000 |
3 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
1 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
2 |
Good, Calculated |
|
|
12:00:32.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
1 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
3 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate Start Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:10.000 |
10 |
Good, Partial |
|
|
12:00:20.000 |
20 |
Good |
|
|
12:00:40.000 |
|
Bad |
|
|
12:00:50.000 |
50 |
Good |
|
|
12:01:10.000 |
70 |
Uncertain |
|
|
12:01:20.000 |
80 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:25.000 |
20 |
Good |
|
|
12:00:39.000 |
30 |
Good |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:12.000 |
60 |
Good |
|
|
12:01:23.000 |
70 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:25.000 |
20 |
Good |
|
|
12:00:39.000 |
30 |
Good |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:12.000 |
60 |
Good |
|
|
12:01:23.000 |
70 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate End Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:10.000 |
10 |
Good, Partial |
|
|
12:00:30.000 |
30 |
Good |
|
|
12:00:40.000 |
|
Bad |
|
|
12:01:00.000 |
60 |
Good |
|
|
12:01:10.000 |
70 |
Uncertain |
|
|
12:01:30.000 |
90 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:28.000 |
25 |
Good |
|
|
12:00:42.000 |
|
Bad |
|
|
12:00:52.000 |
50 |
Good |
|
|
12:01:17.000 |
70 |
Uncertain |
|
|
12:01:30.000 |
90 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:02.000 |
10 |
Good, Partial |
|
|
12:00:28.000 |
25 |
Good |
|
|
12:00:42.000 |
|
Bad |
|
|
12:00:52.000 |
50 |
Good |
|
|
12:01:17.000 |
70 |
Uncertain |
|
|
12:01:30.000 |
90 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate StartBound Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData, Partial |
|
|
12:00:16.000 |
16 |
Good, Interpolated |
|
|
12:00:32.000 |
30 |
UncertainDataSubNormal, Interpolated |
|
|
12:00:48.000 |
|
BadNoData |
|
|
12:01:04.000 |
64 |
UncertainDataSubNormal, Interpolated |
|
|
12:01:20.000 |
80 |
Good, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData, Partial |
|
|
12:00:16.000 |
16.087 |
Good, Interpolated |
|
|
12:00:32.000 |
26.818 |
Good, Interpolated |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:04.000 |
56 |
Good, Interpolated |
|
|
12:01:20.000 |
|
BadNoData, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData, Partial |
|
|
12:00:16.000 |
10 |
Good, Interpolated |
|
|
12:00:32.000 |
25 |
Good, Interpolated |
|
|
12:00:48.000 |
40 |
Good |
|
|
12:01:04.000 |
50 |
Good, Interpolated |
|
|
12:01:20.000 |
|
BadNoData, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate End Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
16 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
30 |
UncertainDataSubNormal, Calculated |
|
|
12:00:32.000 |
|
BadNoData |
|
|
12:00:48.000 |
64 |
UncertainDataSubNormal, Calculated |
|
|
12:01:04.000 |
80 |
Good, Calculated |
|
|
12:01:20.000 |
|
BadNoData, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
16.087 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
26.818 |
Good, Calculated |
|
|
12:00:32.000 |
40 |
Good, Calculated |
|
|
12:00:48.000 |
56 |
Good, Calculated |
|
|
12:01:04.000 |
|
BadNoData |
|
|
12:01:20.000 |
|
BadNoData, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
25 |
Good, Calculated |
|
|
12:00:32.000 |
40 |
Good, Calculated |
|
|
12:00:48.000 |
50 |
Good, Calculated |
|
|
12:01:04.000 |
|
BadNoData |
|
|
12:01:20.000 |
|
BadNoData, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate Delta Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
10 |
Good, Calculated |
|
|
12:00:32.000 |
0 |
BadNoData |
|
|
12:00:48.000 |
10 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
BadNoData |
|
|
12:01:20.000 |
10 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
5 |
Good, Calculated |
|
|
12:00:32.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
10 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
20 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
5 |
Good, Calculated |
|
|
12:00:32.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:00:48.000 |
10 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
20 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate DeltaBounds Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData, Partial |
|
|
12:00:16.000 |
14 |
UncertainDataSubNormal, Calculated |
|
|
12:00:32.000 |
|
BadNoData |
|
|
12:00:48.000 |
|
BadNoData |
|
|
12:01:04.000 |
16 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
|
BadNoData, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData, Partial |
|
|
12:00:16.000 |
10.731 |
Good, Calculated |
|
|
12:00:32.000 |
13.182 |
Good, Calculated |
|
|
12:00:48.000 |
16 |
Good, Calculated |
|
|
12:01:04.000 |
|
BadNoData |
|
|
12:01:20.000 |
|
BadNoData, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
|
BadNoData, Partial |
|
|
12:00:16.000 |
15 |
Good, Calculated |
|
|
12:00:32.000 |
15 |
Good, Calculated |
|
|
12:00:48.000 |
10 |
Good, Calculated |
|
|
12:01:04.000 |
|
BadNoData |
|
|
12:01:20.000 |
|
BadNoData, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate DurationGood Aggregate scenarios. Duration values are in milliseconds. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
6000 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
16000 |
Good, Calculated |
|
|
12:00:32.000 |
0 |
Good, Calculated |
|
|
12:00:48.000 |
14000 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
Good, Calculated |
|
|
12:01:20.000 |
10001 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
14000 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
16000 |
Good, Calculated |
|
|
12:00:32.000 |
10000 |
Good, Calculated |
|
|
12:00:48.000 |
16000 |
Good, Calculated |
|
|
12:01:04.000 |
13000 |
Good, Calculated |
|
|
12:01:20.000 |
7001 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
14000 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
16000 |
Good, Calculated |
|
|
12:00:32.000 |
10000 |
Good, Calculated |
|
|
12:00:48.000 |
16000 |
Good, Calculated |
|
|
12:01:04.000 |
13000 |
Good, Calculated |
|
|
12:01:20.000 |
7001 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
14000 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
16000 |
Good, Calculated |
|
|
12:00:32.000 |
10000 |
Good, Calculated |
|
|
12:00:48.000 |
16000 |
Good, Calculated |
|
|
12:01:04.000 |
13000 |
Good, Calculated |
|
|
12:01:20.000 |
7001 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate DurationBad Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
10000 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
0 |
Good, Calculated |
|
|
12:00:32.000 |
8000 |
Good, Calculated |
|
|
12:00:48.000 |
2000 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
Good, Calculated |
|
|
12:01:20.000 |
0 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
2000 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
0 |
Good, Calculated |
|
|
12:00:32.000 |
6000 |
Good, Calculated |
|
|
12:00:48.000 |
0 |
Good, Calculated |
|
|
12:01:04.000 |
3000 |
Good, Calculated |
|
|
12:01:20.000 |
3000 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
2000 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
0 |
Good, Calculated |
|
|
12:00:32.000 |
6000 |
Good, Calculated |
|
|
12:00:48.000 |
0 |
Good, Calculated |
|
|
12:01:04.000 |
3000 |
Good, Calculated |
|
|
12:01:20.000 |
3000 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
2000 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
0 |
Good, Calculated |
|
|
12:00:32.000 |
6000 |
Good, Calculated |
|
|
12:00:48.000 |
0 |
Good, Calculated |
|
|
12:01:04.000 |
3000 |
Good, Calculated |
|
|
12:01:20.000 |
3000 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate PercentGood Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
37.500 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
100 |
Good, Calculated |
|
|
12:00:32.000 |
0 |
Good, Calculated |
|
|
12:00:48.000 |
87.500 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
Good, Calculated |
|
|
12:01:20.000 |
100 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
87.500 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
100 |
Good, Calculated |
|
|
12:00:32.000 |
62.500 |
Good, Calculated |
|
|
12:00:48.000 |
100 |
Good, Calculated |
|
|
12:01:04.000 |
81.250 |
Good, Calculated |
|
|
12:01:20.000 |
70.003 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
87.500 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
100 |
Good, Calculated |
|
|
12:00:32.000 |
62.500 |
Good, Calculated |
|
|
12:00:48.000 |
100 |
Good, Calculated |
|
|
12:01:04.000 |
81.250 |
Good, Calculated |
|
|
12:01:20.000 |
70.003 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
87.500 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
100 |
Good, Calculated |
|
|
12:00:32.000 |
62.500 |
Good, Calculated |
|
|
12:00:48.000 |
100 |
Good, Calculated |
|
|
12:01:04.000 |
81.250 |
Good, Calculated |
|
|
12:01:20.000 |
70.003 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate PercentBad Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
62.500 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
0 |
Good, Calculated |
|
|
12:00:32.000 |
50 |
Good, Calculated |
|
|
12:00:48.000 |
12.500 |
Good, Calculated |
|
|
12:01:04.000 |
0 |
Good, Calculated |
|
|
12:01:20.000 |
0 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
12.500 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
0 |
Good, Calculated |
|
|
12:00:32.000 |
37.500 |
Good, Calculated |
|
|
12:00:48.000 |
0 |
Good, Calculated |
|
|
12:01:04.000 |
18.750 |
Good, Calculated |
|
|
12:01:20.000 |
29.997 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
12.500 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
0 |
Good, Calculated |
|
|
12:00:32.000 |
37.500 |
Good, Calculated |
|
|
12:00:48.000 |
0 |
Good, Calculated |
|
|
12:01:04.000 |
18.750 |
Good, Calculated |
|
|
12:01:20.000 |
29.997 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
12.500 |
Good, Calculated, Partial |
|
|
12:00:16.000 |
0 |
Good, Calculated |
|
|
12:00:32.000 |
37.500 |
Good, Calculated |
|
|
12:00:48.000 |
0 |
Good, Calculated |
|
|
12:01:04.000 |
18.750 |
Good, Calculated |
|
|
12:01:20.000 |
29.997 |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate WorstQuality Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
Good |
Good, Calculated, Partial |
|
|
12:00:16.000 |
Good |
Good, Calculated |
|
|
12:00:32.000 |
Bad |
Good, Calculated |
|
|
12:00:48.000 |
Good |
Good, Calculated |
|
|
12:01:04.000 |
Uncertain |
Good, Calculated |
|
|
12:01:20.000 |
Good |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
Good |
Good, Calculated, Partial |
|
|
12:00:16.000 |
Good |
Good, Calculated |
|
|
12:00:32.000 |
Bad |
Good, Calculated |
|
|
12:00:48.000 |
Good |
Good, Calculated |
|
|
12:01:04.000 |
Uncertain |
Good, Calculated |
|
|
12:01:20.000 |
Good |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
Good |
Good, Calculated, Partial |
|
|
12:00:16.000 |
Good |
Good, Calculated |
|
|
12:00:32.000 |
Bad |
Good, Calculated |
|
|
12:00:48.000 |
Good |
Good, Calculated |
|
|
12:01:04.000 |
Uncertain |
Good, Calculated |
|
|
12:01:20.000 |
Good |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
Good |
Good, Calculated, Partial |
|
|
12:00:16.000 |
Good |
Good, Calculated |
|
|
12:00:32.000 |
Bad |
Good, Calculated |
|
|
12:00:48.000 |
Good |
Good, Calculated |
|
|
12:01:04.000 |
Uncertain |
Good, Calculated |
|
|
12:01:20.000 |
Good |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate WorstQuality2 Aggregate scenarios. ProcessingInterval: 00:00:16, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
BadNoData |
Good, Calculated, Partial |
|
|
12:00:16.000 |
UncertainDataSubNormal |
Good, Calculated |
|
|
12:00:32.000 |
Bad |
Good, Calculated, MultipleValues |
|
|
12:00:48.000 |
BadNoData |
Good, Calculated |
|
|
12:01:04.000 |
UncertainDataSubNormal |
Good, Calculated, MultipleValues |
|
|
12:01:20.000 |
BadNoData |
Good, Calculated, Partial |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
BadNoData |
Good, Calculated, Partial |
|
|
12:00:16.000 |
Good |
Good, Calculated |
|
|
12:00:32.000 |
Bad |
Good, Calculated |
|
|
12:00:48.000 |
Good |
Good, Calculated |
|
|
12:01:04.000 |
BadNoData |
Good, Calculated |
|
|
12:01:20.000 |
BadNoData |
Good, Calculated, Partial, MultipleValues |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
BadNoData |
Good, Calculated, Partial |
|
|
12:00:16.000 |
Good |
Good, Calculated |
|
|
12:00:32.000 |
Bad |
Good, Calculated |
|
|
12:00:48.000 |
Good |
Good, Calculated |
|
|
12:01:04.000 |
BadNoData |
Good, Calculated |
|
|
12:01:20.000 |
BadNoData |
Good, Calculated, Partial, MultipleValues |
|
|
12:01:36.000 |
|
BadNoData |
|
|
Historian4 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
BadNoData |
Good, Calculated, Partial |
|
|
12:00:16.000 |
Good |
Good, Calculated |
|
|
12:00:32.000 |
Bad |
Good, Calculated |
|
|
12:00:48.000 |
Good |
Good, Calculated |
|
|
12:01:04.000 |
BadNoData |
Good, Calculated |
|
|
12:01:20.000 |
BadNoData |
Good, Calculated, Partial, MultipleValues |
|
|
12:01:36.000 |
|
BadNoData |
|
The following examples demonstrate StandardDeviationSample Aggregate scenarios. ProcessingInterval: 00:00:20, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
7.071
|
Good, Calculated |
|
|
12:00:40.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0
|
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
7.071
|
Good, Calculated, Partial |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
5 |
Good, Calculated |
|
|
12:00:40.000 |
7.071
|
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
10 |
Good, Calculated, Partial |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
5 |
Good, Calculated |
|
|
12:00:40.000 |
7.071
|
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
10 |
Good, Calculated, Partial |
|
The following examples demonstrate VarianceSample Aggregate scenarios. ProcessingInterval: 00:00:20, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
50 |
Good, Calculated |
|
|
12:00:40.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
50 |
Good, Calculated, Partial |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
25 |
Good, Calculated |
|
|
12:00:40.000 |
50 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
100 |
Good, Calculated, Partial |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
25 |
Good, Calculated |
|
|
12:00:40.000 |
50 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
100 |
Good, Calculated, Partial |
|
The following examples demonstrate StandardDeviationPopulation Aggregate scenarios. ProcessingInterval: 00:00:20, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
5 |
Good, Calculated |
|
|
12:00:40.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
5 |
Good, Calculated, Partial |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
4.082
|
Good, Calculated |
|
|
12:00:40.000 |
5 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
8.165
|
Good, Calculated, Partial |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
4.082
|
Good, Calculated |
|
|
12:00:40.000 |
5 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
8.165
|
Good, Calculated, Partial |
|
The following examples demonstrate VariancePopulation Aggregate scenarios. ProcessingInterval: 00:00:20, StartTime: 12:00:00, EndTime: 12:01:40.
|
Historian1 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
25 |
Good, Calculated |
|
|
12:00:40.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
25 |
Good, Calculated, Partial |
|
|
Historian2 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
16.667
|
Good, Calculated |
|
|
12:00:40.000 |
25 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
66.667
|
Good, Calculated, Partial |
|
|
Historian3 |
|||
|
Timestamp |
Value |
StatusCode |
Notes |
|
12:00:00.000 |
0 |
Good, Calculated, Partial |
|
|
12:00:20.000 |
16.667
|
Good, Calculated |
|
|
12:00:40.000 |
25 |
UncertainDataSubNormal, Calculated |
|
|
12:01:00.000 |
0 |
UncertainDataSubNormal, Calculated |
|
|
12:01:20.000 |
66.667
|
Good, Calculated, Partial |
|
_______