JIRA Reporting - Sprint % Done from Final Sprint Scope

Question

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

Bill Sheboy · Accepted Answer

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

Danut M _StonikByte_ · Accepted Answer

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.