Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Need help reporting on data from previous sprints

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.

2 answers

1 vote
Brant Schroeder Community Leader Nov 12, 2020

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"

Thanks, @Brant Schroeder 

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

__Bill

Like Brant Schroeder likes this

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 Community Leader Nov 12, 2020

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.  

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 Community Leader Nov 13, 2020

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')

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.

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')

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 Community Leader Nov 13, 2020

Tim,

What does your workflow look like?

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 Community Leader Nov 13, 2020

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.

Removing my answer, as Brant's is correct.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira

Announcing the waitlist for Jira Work Management

Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...

868 views 14 20
Read article

Community Events

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

Events near you