Query number of bugs in each sprint

[Yaniv Aharoni]

Hello
I would like to create some kind of report that will count the bugs filed in each sprint.
How it can be done?

[Taranjeet Singh · Accepted solution]

@Yaniv Aharoni You can create a JIRA Filter Report using JQL syntax like below:

sprint = <Sprint ID or Sprint Name> AND issuetype = "Bug" ordered by created DESC

Hope it helps !

[Taranjeet Singh]

@Yaniv Aharoni Did my answer help resolving your query?

[Yaniv Aharoni]

No, I'm looking for report style and not query 

[Taranjeet Singh]

@Yaniv Aharoni You can use custom JIRA Dashboard for your team for reporting. You can use "Two Dimensional Filter Statistics" gadget on your Team's JIRA Dashboard.

https://confluence.atlassian.com/jira064/adding-the-two-dimensional-filter-statistics-gadget-720416991.html

To configure this gadget, you will first need to create a JIRA filter and save it (something like , project = <your project> AND issuetype = Bug order by created DESC, in your case) and then use this filter in the gadget , with 'Sprint' in the Yaxis and 'IssueType" in the Xaxis. It should provide you the report result you are looking for.

As an example, the gadget report will look like below:

You can also change your filter and remove "IssueType = Bug" clause if you want to see all issue types for each Sprint in your project.

Hope it helps !

[Taranjeet Singh]

@Yaniv Aharoni Did my answer help resolving your query?

[Yaniv Aharoni]

Yes

[Ari L]

How can I make a chart of this data with a running average? I made the dashboard board gadget. Any way to make  graph of it or export it?

[Rwiddha Mitra]

@Taranjeet Singh 

I have a similar problems statement and came across your reply above.

I have a question however.

The query you mentioned will not be able to filter bugs that get spilled through sprints as the sprint field shows all the sprints which a given ticket is a part of.

What is the solution in this case? Is there a way to filter the bugs by their reporting sprint?