Comment on page
STRING_MAX_EACH
Collects the maximum value per given group.
STRING_MAX_EACH([MAX_VALUES,] GROUP, VALUE)
Type:
integer
Default: 2,147,483,647
(Optional) The maximum number of groups. Groups beyond this amount are discarded. When omitted, there is effectively no limit.
In some cases, discarding groups via this option may cause some data to be discarded from groups that would otherwise have been kept.
Type: any
The field to group by.
Type:
string
The field to get the maximum value of.
Type:
array
Returns an array of key-value pairs where each
GROUP
is matched to the maximum VALUE
seen for that group.Last modified 1yr ago