[DRAFT]This page is not published. Only visible in development mode.

Aggregate Transform

Use aggregate to collapse rows into summary values. Group with by to get per-group results.

Whole-Table Aggregation

$ Whole-Table Aggregation
$ ctrl+enter to run

Without by, the entire table collapses to a single row.

Group By

$ Group By
$ ctrl+enter to run

Add by { column } to get one row per group.

Multiple Groups

$ Multiple Groups
$ ctrl+enter to run

Group by multiple columns to get finer-grained breakdowns.

Multiple Aggregations

$ Multiple Aggregations
$ ctrl+enter to run

Compute several aggregates in a single pass. Available aggregate functions include math::sum, math::avg, math::min, and math::max.