Need some Help Creating a Chart with Status and Sprint data

Question

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

Alexey Pavlenko _App Developer_ · Answer

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

Bill Sheboy · Answer

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