Settings
| Setting | What it is |
|---|---|
| Rows | The list to total up. |
| Group by | The field whose values become one row each. Rows with no value for it group together. |
| Totals | Every group carries count. A result column is named field_function, for example total_sum. |
Technical details
| Key | Value |
|---|---|
rows | any JSONits `{{ }}` must give an array |
groupBy | text |
aggregates | list of {field: text, function?: "sum" or "avg" or "min" or "max"}, by default [] |
Output
| Field | Type |
|---|---|
rowsGroups | array |
countGroup count | number |
Sample output, and the expression for each field
- count1
- rows
- [0]
- count2
- customer"Café De Zon"
- total_sum211.5
- [0]
Errors
When a step of this node stops a run, the run page shows a code. Look it up:
Example step
The step as a flow file holds it. Replace each value in <…>.
{
"config": {
"aggregates": [],
"groupBy": "",
"rows": "<rows>"
},
"label": "Group",
"type": "list.group",
"version": 1
}