JQL Query for Story points completed

[Alicia Morgan]

 Hey there , Im in the process of taking over an existing team and would like to see how many points per sprint each individual team member completes. 

How would I write that in JQL?

[Walter Buggenhout · Accepted solution]

Hi @Alicia Morgan and welcome to the Community!

There's no straightforward answer to that, I am afraid. It is possible to fetch a list of issues that were completed during a sprint, but it is not so dynamic that it automatically applies to any given sprint.

Let's assume your sprint is called Koala (in JQL this will automatically be updated to an ID, e.g. 131). It has a start and end date and - on top of that - a status (or multiple statuses) mapped to the rightmost column of your active sprint board. We'll take May 1st as the sprint start date and May 15th as the end date and Done as the status representing completed issues.

The following JQL would retrieve all issues completed in your sprint:

Project = "Your Project" AND Sprint = 131 AND Status CHANGED TO Done
DURING (2023-05-01, 2023-05-15)

When you save this JQL filter you at least have the list of issues completed in that sprint. You may then want to export that list to report on the number of story points in each issue.

Moreover, since the dates of the sprint can't be queried separately, you would need to update the query for each next sprint.

With all that in mind, if this is something you want to do on regular basis, you might want to consider looking into more solid reporting solutions from the marketplace that let you enhance Jira's out of the box capabilities.

Hope this helps!

[Hannes Obweger - JXL for Jira]

Hi @Alicia Morgan

just to add to Walter's answer, if you're open to solutions from the Atlassian Marketplace, you may want to check out the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for issue grouping by any issue field(s), as well as sum-ups.

With this, in combination with a query similar to what Walter suggested, you can build a view like this in just a couple of clicks:

Note that JXL can do much more than that: From bulk editing via copy/paste, to support for configurable issue hierarchies, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Rahul_RVS_Support]

Hi @Alicia Morgan 

Welcome to the community !!

If you are open for a mktplace solution, we have built an app for the same use case.

Issue Hierarchy Reports 

Through this app you can visualize the story points completed by assignees. Do Try it out.

Disclaimer : I am part of the team which developed this app