MIN_BY

Returns the value that corresponds to the minimum value of a different field in the time window.

Syntax

MIN_BY(VALUE, SORT)‌

Arguments

VALUE

Type: any

The field to return.

SORT

Type: numeric

The field to sort by.

Returns

Type: any

Returns the VALUE that corresponds to the minimum SORT value.

If the minimum value is not unique, the first VALUE in the set will be returned.