nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Two Dimensional Filter Statistics - Summing Story Points

Michael Jelley

Hi all,

We've encountered the need for a gadget much like the "Two Dimensional Filter Statistics" gadget, but that displays the sum of a numeric field of each issue, e.g. Story Points, instead of the number of issues (default behavior). An example of how we could use this is to display the sum of Remaining Estimate on a per-component, per-fix version basis, and sum of work remaining for unique issues per-component, and per-fix version.

Has anyone encountered a need for this or similar functionality? Anyone implemented anything similar?

Thanks,

Michael Jelley

Accepted answers

Michael Jelley

We solved this by downloading the source for JIRA, and modifying the "Atlassian JIRA - Plugins" bundle (which is easy to deploy to a local JIRA install, it produces a ZIP file).

We found that the Two Dimensinal Filter Statistics gadget code and associated code was already mostly prepared for an "aggregate field", which is what we were wanting here. It just took some modification to:

Set up the two-dimensional-stats-gadget.xml specification to support configuring which field to use (if not showing number of issues).
In TwoDimensionalStatsResource, get a NavigableField from the string field constant, using getNavigableField in FieldManager.
Also in TwoDimensionalStatsResource, get a LuceneFieldSorter from NavigableField.getSorter()
Pass the LuceneFieldSorter down the chain to the TwoDimensionalTermHitCollector constructor, and that (basically) handles the rest.

I find it somewhat curious that Atlassian didn't implement this more thoroughly - the changes made were basically completing what they had already done. *shrugs*

Attached a couple images showing the results, in case anyone else out there wants to emulate this.

Michael Jelley

All comments

Michael Jelley

We solved this by downloading the source for JIRA, and modifying the "Atlassian JIRA - Plugins" bundle (which is easy to deploy to a local JIRA install, it produces a ZIP file).

Set up the two-dimensional-stats-gadget.xml specification to support configuring which field to use (if not showing number of issues).
In TwoDimensionalStatsResource, get a NavigableField from the string field constant, using getNavigableField in FieldManager.
Also in TwoDimensionalStatsResource, get a LuceneFieldSorter from NavigableField.getSorter()
Pass the LuceneFieldSorter down the chain to the TwoDimensionalTermHitCollector constructor, and that (basically) handles the rest.

I find it somewhat curious that Atlassian didn't implement this more thoroughly - the changes made were basically completing what they had already done. *shrugs*

Attached a couple images showing the results, in case anyone else out there wants to emulate this.

Michael Jelley

Karie Kelly1

Was there ever an improvement request put in for this? Such a gadget that totals story points would be EXTREMELY useful for us - we currently have to add them up by month, by team and retrain a trend month-over-month for finance and executives so that they have a high level view of productivity by team.

sstorey

Michael,

Is there any way you could share these changes you have made, this is exactly what we are looking for,

With thanks

Simon

Sean Coates

We would also love that feature. Currently to sum up story points, I have to export all of my issues in to Excel, but Hosted Jira only allows you to export 1000 rows at a time so we have to do multiple exports and paste the results together just to get the data into Excel.

A simple sum of story points with a JQL group by function would be awesome and save a lot of work.

Fernando Ducloux

That sounds just what i've been looking for for the past few weeks. Any chance you could upload that file somewhere to take a look?

thanks!

Christen Lorensen

Yes that is also exactly what I am looking for. Anyway of wresling this gadget out of you?

Justin Leader6

Yes Michael! I'll buy you a beer!

Marla Landolt

I'm a fairly new Jira Agile user, so unsure - was this implemented? Michael's last comment was in 2012. tx in advance

Christen Lorensen

@Marla: No, there are no gadget for the Agile plugin other than the burndown.

Christen Lorensen

@Marla: No, there are no gadget for the Agile plugin other than the burndown.

Sean Coates

No, in spite of Jira touting themselves as a great "Agile" tool, you can't sum up story points. One method we use is to replace story points with a points drop-down that's limited to specific values (1,3,8, etc). Then at least you can do a two dimensional table with point values on one axis, making it easier to add them up. They still won't do the math for you though.

Dinesh Dhinakaran

hi Michael,

i need this code badly please help me out on this.

Dinesh Dhinakaran

hi Michael,

Please guide me to modify the two dimensional gadget to summing story points with respect to components

Danilo Conrad

The feature request below has been raised for this:

https://jira.atlassian.com/browse/JRA-23864

I would recommend you to vote on the issue to increase its visibility with our developers.

Cheers,

Danilo

David Grierson

Danilo,

A quick win could be for Atlassian to reach out to Michael who, it would appear, has already implemented this.

Dg.

Helmer Mourao

I have the same problem.

Jeff Wilde

I created a GreaseMonkey / TamperMonkey script that adds the story points to the board. https://greasyfork.org/en/scripts/16551-add-story-points-to-jira-dashboard

Hieu Le Trung2

where should I add it?

anneck

This thread is old, but still the needed enhancement is not available in Jira.

However I found a workaround in confluence.

Steps to achieve what you need in confluence:

1. Create "Jira Issue/Filter" item. Ensure "story points" column is added to the filter.

2. Save the page with added item in the #1 step

3. Click "Create a pivot table" icon on the filter created in the #1 step

4. Pivot table settings:

calculated column = story points

operation type = sum

row/column labels - whatever you need (in my case it is epic link and scrum team).

Hope that helps.

Duygu Sinem Kılıboz

Hi Jan,

I could not try your solution since Confluence do not have pivot table Macro

I actually want to use Jira Dashboard for this purpose. For example, I want to see sum of story points instead of issue count in "Two Dimensional Filter" dashboard.

Is there a way to do this?

anneck

I think there is no such option in Jira (without any additional plugin or extension)

Jürgen Knuplesch

@jan Thank you you are a genius. It took me bit of time to figure out the handling of pivot tables and Jira tables and the connection in my company, but it works greatly and was worth the effort! (-:

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-development

app

jira-app-development