Collapse an entire table into a single row of sums, averages, counts, minimums, and maximums.
Description
Summarizes a whole table into exactly one output row, with one output column per metric you configure — no grouping column, unlike Group By. Each metric pairs a source column with an aggregation: Sum, Average, Count, Min, Max, First value, Last value, or Nth occurrence. Count, Sum, Average, Min, and Max all ignore blank cells automatically.
Best For
Getting a total or average for a column across an entire table
Counting how many non-blank values a column has
Pulling the first or last value seen in a column, or a specific Nth occurrence
How to Use
1Connect your table
Pass any table into Aggregate's input.
2Add a metric
Pick a column and an aggregation (Sum, Average, Count, Min, Max, First, Last, or Nth occurrence).
3Add more metrics
Add as many column/aggregation pairs as you need — each becomes its own output column.
Tips & Notes
One row total, not one per group
Aggregate always collapses the whole table into a single row. If you need one row per distinct value in some column instead, use Group By.
