Two Dimensional Filter Statistics - Summing Story Points

Michael Jelley September 10, 2012

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

13 answers

1 accepted

16 votes
Answer accepted
Michael Jelley September 25, 2012

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:

  1. Set up the two-dimensional-stats-gadget.xml specification to support configuring which field to use (if not showing number of issues).
  2. In TwoDimensionalStatsResource, get a NavigableField from the string field constant, using getNavigableField in FieldManager.
  3. Also in TwoDimensionalStatsResource, get a LuceneFieldSorter from NavigableField.getSorter()
  4. 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 Kelly
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 12, 2013

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.

Like # people like this
Dinesh Dhinakaran
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 1, 2014

hi Michael,

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

Helmer Mourao October 16, 2014

I have the same problem.

Barbara li February 27, 2015

Hi Michael, Can you share your code? We need this feature to support our high level view of each release. Thanks, Barbara

Kimberly Kohler May 13, 2015

Have you considered packaging your modified plugin code as a new plugin that could be made available to others through the Atlassian Marketplace? I would gladly pay for this plugin rather than spending the time and energy recreating the process you have already gone through. (And it sounds like many others feel the same)

Like Carol Jones likes this
Frits van der Holst October 8, 2015

I really need that indeed....Would safe a lot of time. could you share this code @Michael Jelley ? Kr, Reinder

Hieu Le Trung August 20, 2016

Can you share the code?

Like Michelle likes this
3 votes
anneck June 21, 2019

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 July 2, 2019

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 July 2, 2019

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

Jürgen Knuplesch August 21, 2019

@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! (-:

3 votes
sstorey February 12, 2013

Michael,

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

With thanks

Simon

2 votes
Danilo Conrad
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 11, 2014

The feature request below has been raised for this:

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

Cheers,

Danilo

David Grierson August 5, 2014

Danilo,

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

Dg.

Like # people like this
1 vote
Jeff Wilde January 26, 2016

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 Trung August 18, 2016

where should I add it?

0 votes
Dinesh Dhinakaran
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 1, 2014

hi Michael,

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

0 votes
Sean Coates February 2, 2014

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.

0 votes
Christen Lorensen February 2, 2014

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

0 votes
Christen Lorensen February 2, 2014

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

0 votes
Justin Leader
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 16, 2014

Yes Michael! I'll buy you a beer!

Marla Landolt February 1, 2014

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

0 votes
Christen Lorensen January 15, 2014

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

0 votes
Fernando Ducloux December 8, 2013

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!

0 votes
Sean Coates August 8, 2013

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.

Suggest an answer

Log in or Sign up to answer