Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL query for tracking bugs created in a given Sprint

Hi Community,

My team spends a lot of time each Sprint on fixing bugs which affects the delivery.

I'd like to create a Dashboard that would help me track the number of bugs created by the team each Sprint (depending on the priority, some of those bugs are fixed during the Sprint whereas others are moved to the Backlog).

Which gadget would you recommend for a better visibility and what JQL query should I use?

 

 

2 answers

1 accepted

1 vote
Answer accepted
Pramodh M Community Leader Dec 27, 2021

Hi @Katarzyna Kaźmierczak 

Use the JQL query as 

issuetype = "Bug" AND Sprint = "Sprint Name" AND project = "Project Name"

You can use multiple gadgets

  • Issue statistics
  • Filter Results
  • Use the two-dimensional gadget to show the priority of issues along with issues' status

I would recommend adding the story points for the bugs that you are working in the current sprint, and accordingly you can plan the set of tasks for next sprint along with some bugs that you may get along the way.

Velocity sprint report and Sprint burdown chart will also help analyze the in planning the same

Thanks,
Pramodh

Hi @Pramodh M ,

Thank you for a prompt reply. That's very helpful!

Just to confirm - would the recommended query include all the bugs identified/created in a given Sprint (including those that were moved to Backlog and are not assigned to any specific Sprint)? Or would it only capture those bugs that were created in a Sprint and assigned to it?

I would only like to track bugs that were created during a Sprint (both those assigned to that Sprint and those added to the Backlog). I don't want to track bugs assigned to a particular Sprint (as some of them are pulled from a previous Sprint).

Regards,

Kasia

Hi @Katarzyna Kaźmierczak -- Welcome to the Atlassian Community!

How are you distinguishing defects which are independent of the sprint's work versus ones related to the sprint's work?  Knowing that may help with creating your dashboard.

For example, when using a bug sub-task type for ones resulting from a sprint's work, the reporting is quite easy to distinguish these from other defects.

Regardless, I suggest trying a JQL filter which shows the bugs you want, and then try the two-dimensional filter statistic gadget...with sprint and issue type selected.  That will give you a count by sprint.

Kind regards,
Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

536 views 19 25
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you