aggregate_export
Group rows from a NetSuite export by specified columns and compute aggregate measures (sum, count, avg, min, max) per group.
Instructions
Group rows from a NetSuite export by one or more columns and compute aggregations per group. Each Measure carries column, op (sum/count/avg/min/max), and optional alias for the output key (defaults to {op}_{column}). Groups are returned in first-seen order. Use this instead of query_export when you want summary statistics rather than raw rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| group_by | Yes | ||
| measures | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| groups | Yes |