Hi Team- Looking to see how we can report on the current sprint only and not have multiple columns when I export.
There are some items that aren't finished in the sprint, and if I push to a future sprint, it shows as July+1 for example. When I export from the Issues tab, it shows each sprint separately - screen shot included.
Hi @Katie
It sounds like you’re trying to generate a report that focuses on the current sprint, with all issues listed under a single sprint column, even if some items span across multiple sprints. Unfortunately, Jira’s built-in export functionality often separates issues by sprint when exporting to Excel, especially if issues are associated with past or future sprints.
Custom JQL Query for the Current Sprint:
sprint in openSprints()
Using an Add-on:
With Time in Status you can get Sprint Report
Also you can get detailed reports (by grid, chart or as a dashboard gadget) filtered the issue list by sprint in add-on
You can also book a live session or contact us at Support - we'll help you with Time in Status.
Add-on developed by my team.
I hope you find this helpful 🚀
Hi @Katie
if you're open to solutions from the Atlassian Marketplace, you may want to have a look at 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 long list of so-called smart columns that aren't natively available, including the last sprint (along with many other sprint-related columns).
This is how it looks in action:
As you can see above, you can easily sort and filter by the last sprint, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.
Of course, you can also export your data - including the last sprint column - to XSLX (Excel or Google Sheets) or CSV in just 2 clicks.
Any questions just let me know,
Best,
Hannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Katie
With built-in features, the only way to do that is to not include the Sprint field in the output. As long as you know the issues are in the current, open sprint, there may be no need to have the column.
As a spreadsheet workaround, you could parse the data for each row to copy the last column with a non-empty value, and then include that in another, calculated formula column
Outside of Jira, there are likely marketplace apps to perform this type of cleanup.
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Katie A tried and battle-tested reporting solution is Better Excel Exporter for Jira, which allows you to export sprint reports from Jira to Excel.
To export a sprint report using Better Excel Exporter, follow these steps:
Open the Active Sprint Board
Select the “...” Menu
Export Sprint Report
Choose the option to export a sprint report provided by Better Excel Exporter.
Analyze and Share
Use the exported file to perform further analysis or share it with your team.
This method provides a powerful alternative to Jira’s native reports, offering deeper insights.
Learn more about this flexible way to export sprint reports from Jira to Excel.
(I'm part of the Midori team developing Better Excel Exporter for Jira.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.