Grouping functions

Reference documentation for Expressif functions in the grouping scope.

Name	Overview
cube	Expands a grouping into all combinations of retained and aggregated dimensions.
drill-down	Refines each existing group by appending dimensions derived from its values.
drill-up	Derives keys from existing grouping keys and merges matching groups into one grouping level.
drop-empty-groups	Removes groups whose value collection contains no items.
filter-groups	Keeps whole groups whose group-level predicate evaluates to true.
grouping	Constructs a grouping from zero or more pairs. Spread arguments expand arrays of pairs in place.
grouping-sets	Expands a grouping into explicitly declared sets of retained key dimensions.
map-groups	Transforms each group’s value collection while preserving its key and position.
roll-up	Expands a grouping into its original level and progressively coarser prefix levels.
summarize	Evaluates an expression once for each group and returns a dictionary from group keys to summary values.
summarize-against	Summarizes each group against one summary of all grouped values and returns an ordered dictionary.
top-groups	Keeps up to count complete groups in descending ranking order.