Need help reporting on data from previous sprints

[Tim Tidmarsh]

Is it possible to go back for each of the past 6 sprints and pull data for each Dev.  I'm only interested in seeing what they moved to certain status columns.

[Brant Schroeder]

Tim,

You could use JQL to pull that information.  Just put the statuses in that you are interested in and the date range of the sprint and who changed them.

project = "Project Name" AND status changed FROM "Status A" TO "Status B" DURING ('yyyy/MM/dd', 'yyyy/MM/dd') BY "username"

Or for multiple statuses

project = "Project Name" AND status changed FROM "Status A" TO ("Status B", "Status C") DURING ('yyyy/MM/dd', 'yyyy/MM/dd') BY "username"

[Bill Sheboy]

Thanks, @Brant Schroeder 

I did not know the BY clause would work with status CHANGED.

__Bill

[Tim Tidmarsh]

Thanks Brant, I misstated the use case.  I just want to show the issues that have the statuses of done and code review for a particular assignee for a given sprint.

I don't want to show the length of time that it took the issue to move from one status to another, although that will help in other reports.

Thank you for the quick response.

[Brant Schroeder]

Tim,

  Sorry if I was not clear.  The reason I suggested using dates is you can align those dates with when the sprint ran.  Is you use sprint = "SprintName" it could pull in transitions outside of the sprint run date.  The dates do not have anything to do with the length of time the issue took to move but when the transition could have occurred.  

[Tim Tidmarsh]

Hi Brant, thank you.  Here's my JQL statement:

project = "projectX" AND status = ("Done") DURING ('2020/10/26', '2020/11/06') 

but I'm getting this error:

Error in JQL Query: The EQUALS operator does not support the use of the during ("2020/10/26", "2020/11/06") predicate.

I'm just looking for issues with the status of Done for that time period in projectX.

[Brant Schroeder]

Tim,

During is looking for some sort of change during a time period.  Since the status you have is a specific static value. it will give an error.    You could use the following JQL but it might not get you exactly what you need:

project = projectX AND status = Done AND updated >= 2020-10-26 AND updated <= 2020-11-06

I would suggest do the following:

project = projectX AND status changed FROM ("Any Statuses that can transition to Done", "Status C") TO (Done) DURING ('2020/10/26', '2020/11/06')

[Tim Tidmarsh]

Thanks Brant, this cleared up the errors but I'm not getting any results using this query:

project = "projectX" AND status changed from ("QA") TO (DONE) DURING ('2020/04/26', '2020/11/06')

I should see hundreds of tickets that went from QA to Done.

[Tim Tidmarsh]

Interesting I changed the query to this and got 431 hits, although this is low, it's good to see some results:

project = "projectX" AND status changed from ("queue") TO (DEVELOPMENT) DURING ('2020/04/26', '2020/11/06')

[Tim Tidmarsh]

I updated the dates to just ('2020/10/26', '2020/11/06') which reflects that last sprint and only got 5 hits.  Should have been dozens.  I'll continue to tinker...but if you have any thoughts I'm all ears...you've been incredibly helpful...thanks!

[Brant Schroeder]

Tim,

What does your workflow look like?

[Tim Tidmarsh]

It doesn't have any restrictions.  Tickets can move from any column to any column.  We have these columns:  Queue, Development, Code Review, Merged to Dev Branch, QA, Ready for Release and Done.

[Brant Schroeder]

If you can go from every status to development try this and see what it gets you.

project = "projectX" AND status changed from ("Queue", "Code Review", "Merged to Dev Branch", "QA", "Ready for Release", "Done") TO (DEVELOPMENT) DURING ('2020/10/26', '2020/11/06')

Please make sure that the status are correct as they are case sensitive.

[Bill Sheboy]

Removing my answer, as Brant's is correct.