Is there any report or query with which I can know the spillover count from a given sprint?

[Deepika Dandala]

In any given sprint, Is there any report or Jquery with which I can know the spillover count from a given sprint?

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Deepika Dandala

if you look at the Jira Software's Sprint Report, there's a section named "Issues not completed". From a quick look at it, it lists issues that are not completed right now (as opposed to when the sprint was closed), so it may not be overly useful when you look at a sprint that lies further in the past.

Taking a step back and thinking about the "algorithm" behind what you're after, I think you'd have to find 

the number of issues that have been in sprint X, but where sprint X is not the last sprint they've been in.

Does this sound about right? I could imagine that you can figure this out via Jira Automation - but someone else would have to lean in for the details.

Alternatively, if you're open to solutions from the Atlassian Marketplace, I think this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available - including an issue's last sprint. With this, you can easily filter for issues that have been in a certain sprint (say "Amsterdam"), but where this sprint is not their last sprint, like so:

This just works - there's no scripting whatsoever required.

Any questions just let me know,

Best,

Hannes

[Deepika Dandala]

Thanks Hannes.

Is this something that comes as an add-on through JIRA or to be purchased?

I am looking to add the no. of issues (and also the list) to one of my Dashboards to show how many got spilled over to next sprint.

[Hannes Obweger - JXL for Jira]

Hi @Deepika Dandala

JXL is an add-on (or "app", as it is called in Jira) that can be installed via the Atlassian Marketplace. You can trial any app for free for 1 month, and after that, the price depends on the number of users on your Jira site. For up to 10 users, JXL is completely free, forever.

I should add that JXL doesn't currently have a dashboard gadget (although that's something we want to add soon), but many of our customers simply use a JXL sheet as a "de-facto dashboard".

Best,

Hannes

[Deepika Dandala]

Ok, thanks Hannes.

Also can you help me if there is a way that I can just look at the no. of issues (and also the list) spilled over to next sprint with the help of any JQL?