Need some Help Creating a Chart with Status and Sprint data

Andrea Wills
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 25, 2024

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 

2 answers

0 votes
Alexey Pavlenko _App Developer_
Atlassian Partner
October 31, 2024

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:

image.png

Screenshot #2:

image.png

Best regards,
Alexey

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 26, 2024

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

Suggest an answer

Log in or Sign up to answer