Report on how many times an issue has been moved between sprints

Our Ops group does weekly sprints and it's worked fairly well for most of the engineers.  However some are not getting into the swing of things as represented by issues being continuously bumped from one sprint to the next to the next.  

I see individual ticket updates that list all the previous sprints and the new one, but I'd like to somehow report on this.  I think I'm looking a list of open issues in a sprint, sorted by the number of times the issue has been moved between sprints.  There a way to do this?

1 answer

JIRA stores this information in the sprint report, not in the issue. The only way it's stored in the issue is if you close the sprint with the unresolved issue inside it and it gets automatically moved to the next sprint / backlog. This way, the issue will have in the agile box a list of all the sprints it's been through:

image2016-8-26 12:8:34.png


If people move the issue from the sprint to the next one before the sprint is closed, you lose this information and you can only find it in the individual Sprint Reports. Maybe you can assign specific permissions not allowing to remove items from the sprint?  I don't know if that is worth it for you.

Thanks Ovidiu - The concern is not issues moved before the sprint is closed, but issues that are still open when the sprint is closed.  I see the list of all the sprints an issue has been through looking at the individual issues, but I would like to report on issues that have been move more than X times.

I would also like to know what sprints the issue has been in, was trying to see if issues had been in my last 3 sprints

sprint = 119 AND sprint in closedSprints()

works fine but I get issues in any of a 10s of last sprints, I want to specify which closed sprints like 

sprint = 119 AND sprint in closedSprints(111, 99, 88)
sprint = 119 AND sprint in closedSprints(-3)


but neither seems to change the output

Well if you know the list of closed sprints that you want to search through then you don't really need the closedSprints() formula, no? You could just write:

sprint = 119 AND sprint in (111, 99, 88)

Assuming 119 is an open sprint and 111, 99 and 88 are closed sprints, it should show you all issues which are in your open open sprint and were in any of the 3 (now closed) sprints.

Thanks, that was exactly what I wanted

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

244 views 6 0
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