You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
In any given sprint, Is there any report or Jquery with which I can know the spillover count from a given sprint?
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,
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".