VALUE
for each GROUP
.MIN_EACH([MAX VALUES, ]GROUP, VALUE)
GROUP:
A grouping field.
VALUE:
An expression of a NUMERIC type that can be ordered.
MAX VALUES:
An expression of INTEGER type for how many values to return
(Default 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.
WhenMAX VALUES
is omitted, the limit is simply set to the default value. GROUP
type and the value corresponds to the VALUE type (numeric).MIN_EACH
only appears as an option in the ADD AGGREGATE dialog when the source data is hierarchical.
Trying to aggregate MIN_EACH
, when the data is tabular, is likely to result in an error message.
MIN_EACH
can produce output in an array.