RawTotal Mode
Retrieves the arithmetic total (sum) of sampled values for each interval.
- Value
-
The sum of the good quality values of all raw samples in the interval. All bad quality samples are ignored.
- Quality
-
Percent good is always 100, even if the interval does not contain any raw samples or it contains only bad quality samples.
- Example: Calculating the Raw Total
-
The following example demonstrates that only good quality samples are included in the sum. Perform the fol- lowing query on the same data set as that in the Count example above:
select timestamp, value, quality from ihrawdata where samplingmode=calculated and calculationmode=rawtotal and timestamp >= '29-Mar-2002 13:30' and timestamp <= '29-Mar-2002 14:30' and tagname = counttag and intervalmilliseconds = 10MTime Stamp Value Quality 29-Mar-200213:40:00.000 0.00 100.00 29-Mar-200213:50:00.000 0.00 100.00 29-Mar-200214:00:00.00 22.00 100.00 29-Mar-200214:10:00.000 0.00 100.00 29-Mar-200214:20:00.000 0.00 100.00 29-Mar-200214:30:00.000 4.00 100.00 If the same start and end time are used, but the time span is treated as a single interval, then all values are added together:
select timestamp, value, quality from ihrawdata where samplingmode=calculated and calculationmode=rawtotal and timestamp >= '29-Mar-2002 13:30' and timestamp <= '29-Mar-2002 14:30' and tagname = counttag and numberofsamples=1Time Stamp Value Quality 29-Mar-200214:30:00.000 26.00 100.00 Even though the time span covers all raw samples, only the two good quality samples are used in the calculation: 26 = 22 + 4
- Anticipated Usage
-
RawTotal mode is useful for calculating an accurate total when a sufficient number of raw samples are collected. Note that unlike ihTotal, this is a simple sum with no assumption that the values are rate values.