Skip to main content


The aggregation pipeline allows any combination/ordering of the following stages.

FilterReturn records that match a critera
GroupCalculate measure(s) in total or across mutually-exclusive groups
AggregateLike Group but allows overlapping groups, pivot and more
SortSort records by one or more fields
LimitReturn a maximum of N records
SkipReturn all records excluding the first N
Add fieldsAdd computed fields
Drop fieldsDrop fields
Rename fieldsRename fields
Add window fieldsAdd fields using windowed operations
SelectSelect fields from input records (and optionally add fields)
StackAppend rows from a second set of records
JoinAppend columns from a second set of records
UnPivotConsolidate columns into rows