how do you the number of completed/closed tasks vs number of not completed tasks in pervious sprint

[Amr Abddelaziz]

how do I know the number of completed/closed tasks vs the number of not completed tasks in the previous sprint, also how many tasks been moved to the next sprint?
the reports show that as a diagram not in numbers!

[Bill Sheboy · Accepted solution]

Hi @Amr Abddelaziz -- Welcome to the Atlassian community!

Have you reviewed the Sprint Report to see if that will meet your needs?  Please see this documentation: 

https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-sprint-report/

Regarding the number of items moved to the next sprint, you would need to look at that next sprint to see which items were carried forward... not the prior sprint.  Try looking at the Sprint field for multiple values indicating this situation.

Best regards,

Bill

[Amr Abddelaziz]

Hi @Bill Sheboy thanks for your swift reply
but actually this not what I am looking for, simply I am talking about (numbers) ie: the last sprint start with for example 100 tasks ( 70 is completed/closed and 30 tasks are moved to the next )
is that available?

[Bill Sheboy]

Hi!

Short answer summary: Some of the things you are requesting are not in out-of-the-box JIRA scrum support, but may be available with marketplace add-ons.  Let's look at why...

The sprint field for an issue can have multiple values, including all the sprints where the issue was included when the sprint started.  When you report for a specific sprint (Sprint Report, Burn-up, etc.) it is only looking at one sprint.  There is no information about previous or next sprints included, so the report cannot show an item was moved into a next sprint.  The situation gets worse if you change your workflow status, especially for the final board column, as that can impact the concept of "done".

In the past, I have solved this same problem you are describing by exporting the data to a spreadsheet, and creating formulae to detect the sprints an issue was in, and the sprint in which it was completed.  Then, very accurate burn charts can be created (either using story points or item counts).

Another way to solve this and just get the counts is to use filters.  For example, the following will list the items in the current sprint and which have been in a prior, closed sprint.

project = myProject
 AND sprint IN closedSprints()
 AND sprint IN openSprints()
 ORDER BY Key

Best regards,

Bill