sn_aggregate
Aggregate ServiceNow data using COUNT, AVG, MIN, MAX, or SUM, with optional grouping and encoded query filters.
Instructions
Run aggregate queries (COUNT, AVG, MIN, MAX, SUM) on a ServiceNow table with optional grouping.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| type | Yes | Aggregation type | |
| field | No | Field to aggregate on (required for AVG, MIN, MAX, SUM) | |
| query | No | ServiceNow encoded query filter | |
| table | Yes | ServiceNow table name (e.g. incident) | |
| group_by | No | Group results by this field | |
| display_value | No | Display values mode: true, false, or all |