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 MAX
VALUES
may cause some data to be discarded from groups that would
otherwise have been returned.
MAX VALUES
is optional. If it is omitted there is, in effect, no limit.MAX_EACH
only 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_EACH
can produce output in an array.