Aggregate
Works a list down to a single value.
Fields
| Field | Type | Required | What it does |
|---|---|---|---|
items | jsonata | yes | Expression producing the list. |
operation | one of: count, sum, avg, min, max, first, last, join | What to work out. Defaults to count. | |
field | jsonata | Which value of each item to use, for example price. Only count can do without it. | |
separator | string | join only: what goes between values. |
Output
value, operation, from
Notes
Gaps are skipped rather than counted as zero, and a value that is not a number stops the node and names itself. An empty list gives 0 for sum and count, and null for the rest.