Reporting on Sprints

Katie November 5, 2024

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 separatelyIssues Tab .pngExport to Excel .png - screen shot included. 

4 answers

1 vote
Vitalii_Bobak_SaaSJet
Atlassian Partner
November 12, 2024

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.

Workaround Options:

  1. Custom JQL Query for the Current Sprint:

    • You can create a JQL query to filter only the issues in the current sprint:
      scss
      sprint in openSprints()
    • This query will list all issues currently in the active sprint, reducing the chances of having multiple columns related to different sprints.
  2. Using an Add-on:

    • Consider using an add-on like Time in Status. Add-on provides more advanced filtering and export options, allowing you to generate custom reports without extra columns for previous or future sprints. 

With Time in Status you can get Sprint Report 

image.png

Also you can get detailed reports (by grid, chart or as a dashboard gadget) filtered the issue list by sprint in add-on

image.png

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 🚀

1 vote
Hannes Obweger - JXL for Jira
Atlassian Partner
November 10, 2024

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:

last-sprint.gif

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

1 vote
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 5, 2024

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

0 votes
Levente Szabo _Midori_
Atlassian Partner
November 22, 2024

@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:

  1. Open the Active Sprint Board

  2. Select the “...” Menu

  3. Export Sprint Report
    Choose the option to export a sprint report provided by Better Excel Exporter.

    • This app allows you to generate detailed, customizable Excel reports, including committed vs. completed issues, assignee-based summaries, and more.
      active-sprint-export.pngjira-sprint-report-committed-vs-completed-story-points.png
  4. 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.)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events