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.
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:
@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.
Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...
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