JIRA Reporting - Sprint % Done from Final Sprint Scope

[David Jackson]

Hi 

Is there a way to produce a filter with similar data as in the Velocity report. If not out of the box is there an App available? 

I'd like to export this data and produce a Percentage ticket Done against Committed per Sprint! 

Sprint | Committed | Completed

55 | 36 | 27

56 | 33 | 32

57 | 32 | 32

58 | 32 | 32

[Danut M [StonikByte] · Accepted solution]

Hi @David Jackson,

As mentioned by @Bill Sheboy, this is not possible with Jira's build-in features. The alternative would be to look for an add-on on the Atlassian Marketplace, although it is unlikely that there is an add-on that provides such data at the JQL level.

If you consider the option of installing a Jira add-on, be aware that our Great Gadgets app includes a Team Velocity gadget that calculates and displays the data you are looking for (% Completed from final sprint scope), so no need for data export or other manual work.

If you still want to export the data, the gadget can display a Data tab with a detailed report for each sprint and the issues contained, which you can exported in CSV. 

Danut.

[Bill Sheboy · Accepted solution]

Hi @David Jackson -- Welcome to the Atlassian Community!

That is not possible with the built-in features of JQL filters as the data you show is calculated from the issue histories and sprint information only the reporting.

There are some older REST API endpoints for the sprint reports, but I believe they are no longer supported and probably should not be relied upon.

There are marketplace addons / apps for alternative sprint reporting and dashboard gadgets.  I recommend reviewing some of them, trying to see what helps, and proceed from there.  https://marketplace.atlassian.com/search?hosting=cloud&product=jira

Kind regards,
Bill

[Valeriia_Havrylenko_SaaSJet]

Hi @David Jackson 👋
Welcome to the Community!

If you consider installing third-party add-ons, you can try Time In Status. One of add-on feature - Sprint Performance Report offers helps you monitor the progress and performance of the completed sprint, enabling well-informed decisions.

The completion rate is a metric that measures the percentage of work items or issues completed within a defined sprint. Also take a look at Committed vs Completed Rate.

You can also book a live demo - we'll show you the application inside out and answer all your questions.

Add-on have 30-day free trial and free up to the 10 users.

I hope you find this helpful 🚀

[Alexey Pavlenko _App Developer_]

Hi @David Jackson ,

Unfortunately, it's impossible to achieve what you want using JIRA natively. JQL filters can partially address your issue, but only if you create individual JQL filters for each sprint. To consistently define the completed state, you would need to set the resolution date to match the sprint's end/complete date.

You can use the app I have developed which would provide you with all you need - Multi-team Scrum Metrics & Retrospective.

As committed, you can use either the Initial Scope or Final Scope, which you can adjust in the app. Additionally, you can analyze all this data using the drill-down feature. For example:

Additionally, you can group all sprints by months, quarters, half-years, or years and perform drill-down analysis there as well.

Best regards,
Alexey