Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Can I get a report for the number of issues per user, per sprint

I want to know who my most productive developers are and I need a query to determine who had what issues/bugs etc in the sprint, and how long they stayed in each part of the workflow.

4 answers

1 accepted

0 votes
Answer accepted


You can see issues in a sprint by executing the following JQL:

sprint = Srprint1

But to get information about how long an issue was in a status, you would need an add-on.

For example, you could use this add-on: 

I'm actually wanting to collect metrics for individuals. For example, I'd like to know how many issues Person A worked on during the sprint, how long they were in each point in the workflow, and time from start to finish. 

You would need a reporting add-on for it. Have a look at the EasyBi add-on:

Like athomas3 likes this
0 votes

A new way to create a Jira sprint report by user is possible with a dedicated report template by Better Excel Exporter for Jira! You can get an understanding of how workload is distributed among assignees and much more!

Follow this step-by-step guide on how to create a Jira sprint report in Excel:



(Please note that Better Excel Exporter for Jira is a paid and supported app and I'm part of the team developing it.)

If you would like to see how far you can get without add-ons... You could use the control chart and add quick filters on your board for each assignee. It probably does not answer all of your question but it will answer how much time issues remain in a certain status, averages et cetera.

0 votes

@Andrew ThomasAlso, you can try app Time in status for Jira Cloud by SaaSJet . One of its reports "Assignee time" will help you. Just filter data by Assignee or Reporter and you will get information about all issue that was assigned to that employee. Besides that, you can see a time that he and other persons were spent on this issue.2019-10-02_15-28-24.png

Suggest an answer

Log in or Sign up to answer