Need a chart( showing %) for the number of tasks completed & those moved to backlog.

[Lakshmi Ganesh]

I need to prepare a chart (in percentage) more like an Issue statistics report showing 

1. Number of tasks completed in the sprint

2. Number of tasks carried forward to the new sprint

3. Number of tasks moved to backlog from the sprint.

Say suppose 50 user stories are worked on, 10 got moved to the backlog, 10 are carried forward for the new sprint and 30 stories are completed. How do I derive at a chart explaining this? Can someone help?

[Bryce Lord · Accepted solution]

Hi @Lakshmi Ganesh !

I believe the chart you're looking for is the Sprint Report! This can be accessed under "Reports" within your Jira Software project.

Within the sprint report you can view the Sprint burndown as well as the Status Report which shows:

• Completed Issues: Issues completed within the sprint
• Issues Not Completed: Issues not completed within the sprint (including those carried forward to the next sprint)
• Issues Removed From Sprint: Issues removed from the sprint, typically to the backlog or another sprint.

Here is a great link with more information on the sprint report: View and understand the sprint report 

Hope this helps!

[Lakshmi Ganesh]

Thanks much!! I have a quick question. I tried this, but the problem is we have created all the user stories as tasks which in turn has a lot of subtasks. So is there a possibility to change the user story ( available as y axis element) in Sprint report to task. If so, can you please advise how it can be done.

[Lakshmi Ganesh]

And again, am able to see the report. But I need a visual representation as a chart or Issue statistics (in %) how much % is completed, % moved to next sprint and % moved to backlog

[Bryce Lord]

Of course! Tasks and other standard issue types will appear within the Sprint Report, sub-task issue types will not appear.

Ahh unfortunately there isn't a great out-of-the-box solution that I'm aware of for gathering those statistics. A couple of options you may want to look into are pulling the information to manually calculate through a spreadsheet, or leveraging a BI tool, such as eazyBI, to create a more automated solution.

[Martins Vanags -eazyBI-]

Hi @Lakshmi Ganesh 

with eazyBI you can anlyze the sprint scope changes.

Check several report examples here:

https://eazybi.com/accounts/1000/dashboards/5956-sprints-overview

Perhaps Sprint issue balance report is one you are looking for:

https://eazybi.com/accounts/1000/cubes/Issues/reports/243468-sprint-issue-balance

Martins / eazyBI