Use the gadget
JQL recipes
Copy a query, change the project key, and pick the display that fits.
| KPI | JQL | Suggested settings |
|---|---|---|
| Open bugs (lower is better) | project = SHOP AND type = Bug AND statusCategory != Done | Gauge, target 10, lower is better |
| Resolved per week | project = SHOP AND statusCategory = Done | Trend by Resolved, weeks |
| Created per week | project = SHOP | Trend by Created, weeks |
| Overdue | project = SHOP AND duedate < now() AND statusCategory != Done | Number, target 0, lower is better |
| Unassigned in progress | project = SHOP AND assignee IS EMPTY AND statusCategory = "In Progress" | Number, lower is better |
| Story points done this sprint | project = SHOP AND sprint in openSprints() AND statusCategory = Done | Number, Sum of Story Points |
| High priority open | project = SHOP AND priority in (Highest, High) AND statusCategory != Done | Gauge with a target |
Any saved filter's JQL works too: open the filter in Jira, copy its query and paste it into the gadget.