How to retrieve the number of sprints a Jira ticket passed through before closure using the Reports and Timesheets for Jira app

This article explains how to create a report that displays how many sprints a Jira ticket passed through before it was closed.

Problem

Users need to determine how many sprint cycles an issue has passed through. This can be essential for tracking issue delivery velocity and understanding blockers or delays in agile workflows.

Jira does not natively display the count of sprints an issue has gone through. Sprint changes are stored in the issue's history, and extracting this information requires filtering and configuring historical data fields.

Instructions

Follow these steps to generate a report showing how many sprints a Jira ticket took to close:

1. Filter the History Field
   Set the field to Sprint and hide this field in the report view.

2. Use the History New Value field
   This field displays all sprints the issue has passed through. For example, if an issue moved through three sprints, the rows might look like:

   • ARTS Sprint 1

   • ARTS Sprint 1, ARTS Sprint 2

   • ARTS Sprint 1, ARTS Sprint 2, ARTS Sprint 3

3. Filter only Final Sprint Entry
   Use the field Is Current (New Value) and set the filter to Y. This ensures only the final sprint entry is shown, which represents the total count.

4. Add the Issue Sprints Count field
   This displays the total number of sprints the issue has been through.

5. Add additional fields
   Include fields like Assignee and Project for context.

6. Report Output
   The final report will show only one row per issue, including the complete sprint history and sprint count.

The report configuration will appear as shown below.

Open