visualize_aggregate
Build real-time charts from ServiceNow records grouped by any field. Outputs chart-ready data, a Teams Adaptive Card, markdown table, and summary.
Instructions
Build a real-time chart of ServiceNow records grouped by a field (e.g. incidents by priority, cases by state). Returns chart-ready data, a Teams Adaptive Card (Chart.*) to drop into a Copilot Studio "Send an adaptive card" step, a markdown table, and a summary. Read-only.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>",
"group_by": "<group_by>"
},
"name": "visualize_aggregate"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Keep the top N groups by count (default 12) | |
| query | No | Optional encoded query filter, e.g. "active=true" | |
| table | Yes | Table to aggregate, e.g. "incident", "sn_customerservice_case" | |
| title | No | Optional chart title | |
| group_by | Yes | Field to group by, e.g. "priority", "state", "category", "assignment_group" | |
| chart_type | No | column (default) | bar | pie | donut |