Links
Comment on page

LAST_EACH

Gets an array of the last values per group in the time window.
Note that this function is non-deterministic.

Syntax

LAST_EACH([MAX_VALUES,] GROUP, VALUE)

Arguments

MAX_VALUES

Type: integer
Default: 2,147,483,647
(Optional) Limits the number of key value elements in the output.

GROUP

Type: any
The field to group by.

VALUE

Type: any
The field to get the first value of.

Returns

Type: array
Returns array of key-value pairs where each GROUP is matched to the last VALUE seen for that group.
Last modified 1yr ago