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 VALUESmay cause some data to be discarded from groups that would otherwise have been returned. When
MAX VALUESis omitted, the limit is simply set to the default value.
GROUPtype and the value corresponds to the VALUE type (numeric).
MIN_EACHonly 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_EACHcan produce output in an array.