Reference to the rawmin() function

Summary

rawmin(<tsExpression>[,metrics|sources|sourceTags|pointTags|<pointTagKey>])

Returns the lowest value across the set of time series described by the expression. The results are computed from real reported data values only. Use min() to include interpolated values.

Parameters

ParameterDescription
tsExpression Expression describing the set of time series to return raw minimums for.
metrics|sources|sourceTags|pointTags|<pointTagKey> Optional group by parameter for organizing the time series into subgroups and then returning the raw minimum for each subgroup. Use one or more parameters to group by metric names, source names, source tag names, point tag names, values for a particular point tag key, or any combination of these items. Specify point tag keys by name.

Description

The rawmin() aggregation function finds the lowest (minimum) reported data value at each moment in time, across the time series that are represented by the expression.

By default, rawmin() returns a single series of minimums by aggregating data values across all time series. You can optionally group the time series based on one or more characteristics, and obtain a separate series of minimums for each group.

A raw minimum is computed only from real values reported at a given moment in time. No interpolation is performed to fill in data gaps in any time series. Use min() if you want the minimums to include interpolated values wherever possible. Using rawmin() instead of min() can significantly improve query performance.

Grouping

Like all other aggregation functions, rawmin() returns a single series of results by default. You can include a group by parameter to obtain separate raw minimums for groups of time series that share common metric names, source names, source tags, point tags, or values for a particular point tag key. The function returns a separate series of results corresponding to each group.

You can specify multiple ‘group by’ parameters to group the time series based on multiple characteristics. For example, rawmin(ts("cpu.cpu*"), metrics, Customer) first groups by metric names, and then groups by the values of the Customer point tag.

Example

In the following example, we use the rawmin aggregation function to show the minimum value for each availability zone over time.

raw min