nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL query for tracking bugs created in a given Sprint

Katarzyna Kaźmierczak

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?

Accepted answers

Pramodh M

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

All comments

Pramodh M

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

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

Thanks,
Pramodh

Katarzyna Kaźmierczak

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

Bill Sheboy

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud