MIN/MAX
- Last UpdatedMar 20, 2025
- 1 minute read
The MIN() and MAX() functions produce a stream of results selecting the minimum or maximum value of a stream or array of streams. The returned timestamps correspond to the minimum/maximum values retrieved, rather than the beginning of the time interval.
When using MIN() or MAX() in a query, if no resolution is specified, the behavior is the same as minimum or maximum retrieval modes with no resolution specified; the duration between the start and end times is divided into 100 equal cycles, and the minimum/maximum values are calculated for each cycle.
Syntax
|
Format |
Stream = MIN(Stream or ArrayOfStreams) Stream = MAX(Stream or ArrayOfStreams) |
|
Arguments |
Stream - A time-ordered vector of values. ArrayOfStreams - An array of streams. See Selecting an array of streams. |
|
Description |
Returns the minimum (or maximum) value of a stream or array of streams. |
|
Format |
Stream = MIN(Stream or ArrayOfStreams, TimeInterval) Stream = MAX(Stream or ArrayOfStreams, TimeInterval) |
|
Arguments |
Stream - A time-ordered vector of values. ArrayOfStreams - An array of streams. See Selecting an array of streams. TimeInterval - The time interval over which minimum or maximum values are calculated. |
|
Description |
Returns the minimum (or maximum) value of a stream or array of streams over the specified time interval. |