Table Aggregate
Aggregate data in a workspace table (groups, metrics, pagination).
Type
table.aggregateFolder
tableChannels
Any
Pipe
Value
Scope
Any
Table Aggregate summarizes rows in a table. Filter first (WHERE), compute metrics, optionally Group By, then filter groups (Having), sort, and paginate.
Default pagination is All. Default operation is a count.
Configure
| Setting | Description |
|---|---|
| Table | Workspace table (required) |
| Filters (WHERE) | Optional conditions on rows before grouping |
| Aggregations | Operations to compute — count, sum, avg, min, max — with a field (except count) and optional alias |
| Group By | Optional table field to group on |
| Having | Optional conditions on the grouped results |
| Sort (ORDER BY) | Optional sort on group results |
| Pagination | One, All, Limit/Skip, or Limit/Page. Default All |
| Limit / Skip / Page | Shown for Limit/Skip or Limit/Page |
Handles
| Handle | Role |
|---|---|
| In (target) | Incoming connection |
| Out (source) | Continues after the aggregation |
Pipe schema
The next block reads this on the data pipe (pipe.value). The value is an object:
| Key | Type | Description |
|---|---|---|
rows | list | One object per group. _id is the group key (null when there is no group). Each operation alias is a property |
total | number | Number of groups |
Use case
- Count open tickets, or sum order amounts by status.
- Feed group rows into For Of to notify each category owner.