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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

543 views 6 12
Read article

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