Need a chart to display the number of bugs open and closed within several sprints . I tried a custom SQL that lists bugs with
status != Cancelled and (created >= 2024-08-11) ORDER BY created ASC, resolutiondate ASC
Chart by Sprint, Group By Status
Hi @Andrea Wills ,
Unfortunately, JIRA natively doesn't provide such visualization functionality. If you are open to custom JIRA apps, you can try the one I have created - Multi-team Scrum Metrics & Retrospective.
Here is the view you can achieve using the app:
Screenshot #1:
Screenshot #2:
Best regards,
Alexey
Hi @Andrea Wills -- Welcome to the Atlassian Community!
I do not believe there are any built-in charts / dashboard gadgets that show what you ask. Are you using a marketplace addon to do this charting? If so, have you checked the documentation for that app?
And FYI, Jira has a Jira Query Language (JQL) to find issues; it is not a SQL. (This may save you some time if you are looking for SQL features that do not exist with JQL.)
For the query you are trying, you could add a clause to test the issue type also:
project = yourProjectName
AND issueType = Bug
AND status != Cancelled
AND created >= "2024-08-11"
ORDER BY created ASC, resolutionDate ASC
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.