Search code examples
jirajira-agile

JIRA agile - find the total number of issues completed in each sprint

In JIRA Agile I know I can look at the sprint report to see all the issues completed in that sprint and manually count them.

I can also query for all issues completed in a particular sprint like: project = MYPROJECT AND status = Done AND Sprint = nn

However what I want is a count of the total number of issues completed in each sprint. Is there a way to do this with JQL?

Solution

  • I have set up a saved filter with: project = MYPROJECT AND status = Done AND Sprint is not EMPTY AND issuetype in (Bug, Story)

    Then on my dashboard I have added a Two Dimensional Filter Statistics gadget using:

    • the above query
    • X-axis: Issue type
    • Y-axis: Sprint
    • Sort Direction: Descending - to show most recent sprints at the top
    • Show Totals: Yes

    enter image description here

    This is actually better than just the total I wanted as I can also see the breakdown of bugs and stories in each sprint.