The aggregate functions in the table below are supported for all historical data types.
| Aggregate | Value | Time stamp | Composite Ff (DeltaV) status | Composite DvCH (archive) status |
|---|---|---|---|---|
| % Available | From 0–100 percent of time in the interval where historical data is present | Time stamp of the start of the first hole in the interval | Composite of all non-hole samples in the interval and interpolated boundary samples | Composite of all samples in the interval and interpolated boundary samples |
| Count | Number of raw samples, including holes | Time stamp for the start of the interval | Always a constant value: Bad, NonSpecific, NotLimited (0) | Composite of all raw samples in the interval |
| First | Value, if any, of the first raw sample | Time stamp for the first raw sample | Ff status, if any, for the first raw sample | DvCH status for the first raw sample |
| Interpolated | Interpolated value at the start of the interval | Time stamp for the start of the interval | Composite from the raw samples used in the interpolation | Composite from the raw samples used in the interpolation |
| Last | Value, if any, of the last raw sample | Time stamp for the last raw sample | Ff status, if any, for the last raw sample | DvCH status for the last raw sample |
The aggregate functions in the table below are supported for Float, 32-bit signed integer, and 32-bit unsigned integer historical data types.
| Aggregate | Value | Time stamp | Composite Ff (DeltaV) status | Composite DvCH (archive) status |
|---|---|---|---|---|
| Average | Numerical average of non-hole raw samples in the interval and interpolated boundary samples | Time stamp for the start of the interval | Composite of all non-hole samples in the interval and interpolated boundary samples | Composite of all samples in the interval and interpolated boundary samples |
| Maximum | Value from the non-hole raw sample with the largest numeric value | Time stamp corresponding with Value | Ff status corresponding with Value | DvCH status corresponding with Value |
| Maximum Time | n/a | Time stamp corresponding with Maximum Value | Ff status corresponding with Maximum Value | DvCH status corresponding with Maximum Value |
| Minimum | Value from the non-hole raw sample with the smallest numeric value | Time stamp corresponding with Value | Ff status corresponding with Value | DvCH status corresponding with value |
| Minimum Time | n/a | Time stamp corresponding with Minimum Value | Ff status corresponding with Minimum Value | DvCH status corresponding with Minimum Value |
| Time-weighted average | Time-weighted average of non-hole raw samples in the interval and interpolated boundary samples | Time stamp for the start of the interval | Composite of all non-hole samples in the interval and interpolated boundary samples | Composite of all samples in the interval and interpolated boundary samples |
| Total | Totalized value of non-hole raw samples in the interval and interpolated boundary samples | Time stamp for the start of the interval | Composite of all non-hole samples in the interval and interpolated boundary samples | Composite of all samples in the interval and interpolated boundary samples |