aggregate_report
Generate a concise meta description for the aggregate_report tool from NowAIKit MCP server that focuses on its purpose and use case, following all the given instructions.
Instructions
Server-side aggregate REPORT grouped by a field, in ONE query with no 1000-row truncation. Returns per-group record count PLUS averages/sums/mins/maxes of numeric or duration fields — the right tool for a periodic summary like "incident volume by category with average resolution time". Do NOT list raw records for this; use this. For task tables (incident, problem, change_request, cases, etc.) it INCLUDES average resolution time automatically even if avg_fields is omitted. Duration fields come back pre-formatted (e.g. "21 14:03:10"). Returns a stats table (markdown), the rows, a count chart Adaptive Card, and a summary. Read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Keep the top N groups by count (default 25) | |
| query | No | Encoded query filter, e.g. resolved in the last 7 days: "stateIN6,7^resolved_atRELATIVEGT@dayofweek@ago@7" | |
| table | Yes | Table to aggregate, e.g. "incident" | |
| title | No | Optional report title | |
| group_by | Yes | Field to group by, e.g. "category", "assignment_group", "priority" | |
| avg_fields | No | Fields to average per group, e.g. ["business_duration"] or ["calendar_duration"] for resolution time. Comma string also accepted. | |
| max_fields | No | Fields to take the maximum of per group | |
| min_fields | No | Fields to take the minimum of per group | |
| sum_fields | No | Fields to sum per group |