LAST_K

Gets the last k values per group.

Syntax

LAST_K([K], VALUE)

Arguments

K

Type: integer

Default: 1

(Optional) The number of values to return.

VALUE

Type: any

The field to get the last value(s) of.

Returns

Type: array

Returns an array of the last K values of VALUE seen for each group.