JQL to count story points in field

Mark Sim

Hello,

We are a team using Kanban in Jira 7.13.x DataCenter.  I need to count the numeric value in the Story Points field per assignee.  JQL will be build a filter and used to display a dashboard / Gadget (Pie chart showing assignee + total points).

I've already looked at Scriptrunner but all examples are pointing to the below:

project = "Kristians Dev Project" AND "Start Date" >= startOfMonth() AND "End Date" <= endOfMonth() AND issueFunction in aggregateExpression("Total Estimate for All Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()", "Time Spent","timeSpent.sum()")

I am not estimating points.  I am simply wanting to count the Story Points field containing values associated to an assignee.  

 

Thank you

Tom Harris - Old Street

Hi @Mark Sim ,

The app Custom Charts for Jira is able to display the Story Point count you're asking for on a Jira dashboard.

There are a number of charts to choose from including pie charts, bar chart, funnel chart and a simple list.

Your question has come at a perfect time as we've been working on this Story Point count feature for the past few weeks and it has just been released to the Atlassian Marketplace!

Here is an image showing how the functionality works:

 

You can try this out for you self right now on our free interactive app playground.

I hope this is what you're looking for.

Tom