min(), max()

Definition

min() returns the minimum value of the table column. max() returns the maximum value of the table column.

You can use min() and max() with transform commands that support aggregations.

Examples

min()

The following example returns the minimum value for balance column and groups result by operation column.

%dpl
index=crud earliest=-3y
| spath
| timechart min(balance) by operation
example of min() function

max()

The following example returns the maximum value for balance column and groups result by operation column.

%dpl
index=crud earliest=-3y
| spath
| timechart max(balance) by operation
example of max() function

Further Reading