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

[Mike Sebastian]

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....

[Tarun Sapra · Accepted solution]

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.

[Mike Sebastian]

Ah -- thank you!

[Allison Carlson · Accepted solution]

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.

[Mike Sebastian]

Yep -- that occurred to me as well. That's what I'm doing. Thank you Allison!

[Yevhen Rohovets · Accepted solution]

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. 

[Mike Sebastian]

Excellent -- thank you! I wasn't sure about the date format; so it's YYYY-MM-DD  -- right?