MAX_EACH([MAX VALUES, ]GROUP, VALUE)
GROUP:A grouping field
VALUE:An expression of a NUMERIC type that can be ordered
MAX VALUES:The maximum number of groups. Groups beyond this amount will be discarded (Defaults to 2147483647). In some cases, depending on the data distribution, discarding groups via
VALUESmay cause some data to be discarded from groups that would otherwise have been returned.
MAX VALUESis optional. If it is omitted there is, in effect, no limit.
MAX_EACHonly appears as an option in the ADD AGGREGATE dialog when the source data is hierarchical. Trying to aggregate
MAX_EACH, when the data is tabular, is likely to result in an error message:
MAX_EACHcan produce output in an array.