Aggregate
Reduces a column of numbers to a single figure: the total, average, smallest, largest, first, last, or a count of values. This is the standard last step before a KPI card: a whole column in, one headline number out.
Inputs
| Input | Accepts | Required |
|---|---|---|
Series | Series (a list of numbers) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Value (a single number) |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Function | Sum | One of Sum, Mean, Min, Max, First, Last, Count. Default is Sum. |
Example
An Invoices table has an Amount column with 348 rows. Wire it into Aggregate set to Sum for total billings of $4,218,650, and wire that into a KPI card. A second Aggregate on the same column set to Mean gives the average invoice of $12,122; two summary figures from one column, each on its own card.
Tips
Aggregate collapses an entire column to one value; to get a total per region or per month, use GroupBy instead, which produces one row per group. First and Last read the column in row order, so Sort by date upstream to make Last mean "most recent." SeriesIndex does the same job as First and Last but for any position.