JQL on count of story points completed in a sprint

[Sriraman]

would like to identiofy a JQL querry which can give total closed story points in every sprint that has been closed for the project

[Tarun Sapra]

Hello @Sriraman,

As already shared by @Alana Fernando, it's not possible out of the box in JIRA to see the stories burned per sprint of an board/project in a single chart of JQL. Because in JQL you can use the query like "Sprint in (X,Y,Z))" to get the issues from all sprints, but categorizing per sprint is not possible, also lot of issues have multiple "sprint" values in JIRA because an issue might have worked upon in sprint 1,2,3 but closed in sprint 4 thus using JQL you might not get correct results.

I have been able to create chart which shows velocity per sprint of an project/board using the combination of script runner and dataplane plugin. Here's the description as to how to achieve it.

http://www.arsenalesystems.com/docs/display/dataplane/Comparing+Metrics+Across+Sprints

[ZL]

(Sprint = 1908 AND Sprint != 2005) AND issuetype = Story AND status = Done

Ask for Done Stories in (Sprint 1 but not in Sprint 2).  Unfortunately, for each Sprint you would have to do a separate query asking if it is in the Sprint in Question but NOT in the following Sprint.  

[Crystal Newmon]

As a workaround to the above suggestion (because I can't do an add-on for $120 a month just to get the individual velocity calculated, the velocity chart within the project is very helpful. If you click on the Sprint it opens up the Sprint Report, The list of "Completed items" has a link to the far right that says "View issue in Navigator". Click on that and it takes you to the filters page where you can configure the layout how you need it. If your team is documenting story points religiously, then you can total them up per Engineer from each individual Sprint velocity list. Hope this helps. :) 

[Mukesh Jha]

This is helpful. Thanks @Crystal_Newmon

[Alana Fernando]

hi @Sriraman,

it is not possible to filter out sprint names , and total closed stories per sprint in Advance search of default JIRA. instead you can search for closed stories per sprint and get the total value one sprint at a time. 

try below JQL.

Sprint = <sprint ID>   AND type = Story AND  status = Closed 

Other than that, you may export the closed stories to excel and filer out the results by sprint. 

Reference:

• How to search issues from specific Sprint
• Advanced searching

[Tarun Sapra]

Hello @Alana Fernando

Above JQL would give inconsistent results because if an issue is closed in sprint 4 and  now closed but was worked upon in sprint 3 as well thus in JQL if we use JQL "Sprint = Sprint 3" then we might get issues which were worked in sprint 4 and are now closed but were worked upon in sprint 3(as sprint field supports multiple values in JIRA). And we don't want that as we want only the issues which were exclusively closed only in sprint 3. 

I have shared in the below answer as to how it can be achieved. 

[Alana Fernando]

Thanks @Tarun Sapra for the explanation. It really help me improve my knowledge :-)

[Tarun Sapra]

@Alana Fernando - Your welcome! :)

[Karl Hamilton]

Hello Tarun, thanks for sharing but I can not see your solution?  You mention it is “below” but it’s not visible?  Please can you share it? 

thanks