Two Dimensional Filter - add Story point field to yAxis drop down list

[Michelle]

Hi,

We would like to display the total of story point for the issue types in the Two Dimensional Filter within our Agile project dashboard in Jira.

However, the Story Points field is not available in the drop down list.

Has anyone got any idea how to add this field into the drop down list.

Thanks,

[Tarun Sapra · Accepted solution]

Hello @Michelle 

Currently it's not possible to aggregate story points in 2D filter, here's a ticket about it

https://jira.atlassian.com/browse/JRASERVER-62109

Make it possible to summarize Story Points, and other custom fields, in Two Dimensional Gadget or other statistics view

[Tarun Sapra]

Possible duplicate

https://community.atlassian.com/t5/Answers-Developer-Questions/Two-Dimensional-Filter-Statistics-Summing-Story-Points/qaq-p/487500

[Tarun Sapra]

Paid plugin which you can look into for this requirement

https://marketplace.atlassian.com/apps/1211625/sumup-for-jira?hosting=server&tab=overview

[Michelle]

Many thanks Tarun, greatly appreciated :)

[Abhi Singh]

Such a no brainer...can't believe Story Points is not included in the schema by default. Should be able to report out on any numerical field in a two dimensional chart. Another one of those confounding Atlassian moments.

[rvogt@amfam.com]

100% agree.

[Chris Buzon]

You can't do this 'free', but you can do it by cheating. 

Create an automation rule that adds the story points of that tasks/tickets under the epic together (JQL lookup does this, then you can even use the advanced branching rule to do more)...then drop that info into a custom field in the epic itself.

[Elle Prince]

Append this to your JQL

AND issueFunction in aggregateExpression("Total Story Points", "StoryPoints.sum()")

[rvogt@amfam.com]

Not sure this function works in Jira Classic? Are you on Nextgen?

[Afzal Fahim]

This works when going into the filter and clicking advanced then adding the JQL part there.  But how do we show this in the two dimensional widget? I cant find the issueFunction drop down in the widget settings either and when I change the issue function name to one of the drop downs in the jql it no longer works.  

[Houssein Barkallah]

This Function comes with ScriptRunner

[Jose Boretto Blengino]

up