Search to get total number of points completed by issue type?

Question

Hi I'm trying to  construct a search that would tell me  , how many story points have been completed since June 1 of this year?

project = 10611 AND ("Team (Schw)" = MCcc AND issuetype = Story AND status = Done AND createdDate >= 06/01/2019 .... AND SUM THE POINTS....

Yevhen Rohovets · Accepted Answer

Hello,

For this case you can just use JQL for all issue, what resolved 1 June, something like:

resolved >= 2019-06-01 AND resolved <= 2019-06-02 ORDER BY priority DESC, updated DESC

After that SUM Story points in this issue manually.

Allison Carlson · Accepted Answer

Hi Mike,

your question jumped out at me because I've tried to sum up points in the past. Unfortunately , per Atlassian, there isn't currently a way to do this in Jira.

See related question: https://community.atlassian.com/t5/Jira-questions/Total-points-per-label/qaq-p/1090466

When I need to sum up points or hours, I typically run a JQL then export the results to an XLS and doing a sum there.

Tarun Sapra · Accepted Answer

Hello @Mike Sebastian

Out of the box it's not possible to automatically return the sum of story points but if you have a paid plugin like Script runner, then you can do it like this

project = MAD and createdDate > startOfWeek() and "Story Points" is not empty and issueFunction in aggregateExpression("Total story points", "StoryPoints .sum()")

This query will return sum of story points of all issues of project MAD, created this week and which have the field story points.