jira_get_backlog_stats
Get aggregated statistics for JIRA issues using JQL. Group by status, type, priority, assignee, or custom pivot fields, with count, sum, avg, and cardinality aggregations.
Instructions
Get aggregated statistics for issues matching a JQL query. Returns counts grouped by status, type, priority, and assignee by default. Supports custom pivoting on any field pair with aggregation actions (count, sum, avg, cardinality) and flexible field filters.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| jql | Yes | JQL query string (e.g., "project = PROJ") | |
| pivot | No | Custom pivot table configuration | |
| sprint | No | Filter by sprint ID | |
| boardId | No | Filter by board ID (adds project filter based on board's project) | |
| groupBy | No | Fields to group by. If specified, replaces default aggregations with custom groupedBy results. | |
| assignees | No | Filter by assignees (use "unassigned" for unassigned issues) | |
| issueTypes | No | Filter by issue types (e.g., ["Bug", "Story"]) | |
| fieldFilters | No | Additional field-based filters applied via JQL | |
| excludeResolved | No | Exclude resolved/done issues (adds "resolution IS EMPTY" to JQL) |