Can I get the stats for completed sprints that were in a deleted scrum board

We recently changed from using a scrum board to a kanban board in our project. Not needing the scrum board any longer I deleted it not realising that all of the stats that were built from it would also be deleted. Can I find those stats anywhere? I need to get to all the points from each sprint to help maintain a handle on the teams velocity.

1 answer

1 accepted

Ok so as a work around I've realised that the sprint names still exist even though the scrum board is gone. So to get the stats for all stories completed in a sprint I just created a filter with an extra date range for updateDate to catch any edge cases where stories crossed over more than 1 sprint.

Here is the query:

project in (NAME1, NAME2, NAME3) AND issuetype in standardIssueTypes() AND updatedDate < "2016/11/17 09:00" AND updatedDate > "2016/11/02 23:00" AND status in (Closed, Done) AND Sprint = sprint_number ORDER BY status ASC

To use it just replace the NAME1 etc with your projects and change the sprint_number to the sprint number that relates to your sprint name. Adjusting the dates to suit your needs.

Hints:

To find the sprint number, first do a simple search filter by sprint name. Then switch to advanced filter and the number will be filled in already for you.

Dates need to be in the format "yyyy/MM/dd HH:mm"

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,276 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot