MAX_BY

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

Syntax

MAX_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 maximum SORT value.

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