nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query help. carry over sprint to sprint

dan_marcantel

Anyone have a good Jira query that shows what stories are carried over from sprint to sprint.

I have tried old queries with the new company I work with but none work because the way the set it up is so jacked up.

basically I want to see any story that did not reach a done state in one sprint and carried over to the next sprint. Seems to be quite the problem where i am at now. Poor sprint planning.

Any good reporting plugins?

Accepted answers

Jack Brickey

i think that you would need an addon e.g. Scriptrunner or similar. With scriptrunner you could use

issueFunction not in completeInSprint(board name, [sprint name])

but that would only cover a specific sprint. Unsure if there is a way to cover all historical sprints.

All comments

Jack Brickey

i think that you would need an addon e.g. Scriptrunner or similar. With scriptrunner you could use

issueFunction not in completeInSprint(board name, [sprint name])

but that would only cover a specific sprint. Unsure if there is a way to cover all historical sprints.

dan_marcantel

I'll try it

Scott Thurston_22s9a2

I think JIRA should come up with a report that shows all the items that were carried over across multiple sprints. This would help teams identify if they are:

over-committing at the start of sprints
if they are beginning in work that is not really ready for development (thus blocks happen and the story does not complete in the sprint).
If they are sizing stories to low
poor acceptance criteria
etc

Reviewing carryover work from a nice report would really help teams conduct good retros and improve.

Scott Thurston_22s9a2

Would it not be super helpful to have an icon or indicator on issues that are carryover. Make it stand out a bit so it is easier for the team to spot, monitor, track, and helpfully address and improve on.

dan_marcantel

I can't try script runner my company wont let me buy new plugins or even try them.

Yolanda Repetto-Logan

Agree!

George_ Sanju

This does not work.. It is pathetic that JIRA cannot provide a report of story carrying over from one sprint to another. Such a shame for a product to provide the simplest of the report

Mikel.John

I was looking for this exact thing and found what might be a simple solution for people.

1) Write a query of your current sprint. Really 'Sprint in openSprints()" which will always find you the current open sprint.

2) Make a dashboard or go to your dashboard.

3) Add the Pie chart gadget to the dashboard

4) Select your query

5) Select Statistic Type = Sprint

The pie chart will then give you a break down of all of the Sprints as a piece of the pie.

For example

10 items in Sprint 10

6 items in Sprint 9

3 items in Sprint 8

1 item in Sprint 7

Basically this means, you have 1 item that has been in 4 sprints, 3 items in 3 sprints, 6 items in 2 sprints, and 10 items in your current sprint.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud