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
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:
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Michael,
i need this code badly please help me out on this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Michael, Can you share your code? We need this feature to support our high level view of each release. Thanks, Barbara
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I really need that indeed....Would safe a lot of time. could you share this code @Michael Jelley ? Kr, Reinder
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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! (-:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Danilo,
A quick win could be for Atlassian to reach out to Michael who, it would appear, has already implemented this.
Dg.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Michael,
Please guide me to modify the two dimensional gadget to summing story points with respect to components
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Marla: No, there are no gadget for the Agile plugin other than the burndown.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Marla: No, there are no gadget for the Agile plugin other than the burndown.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes Michael! I'll buy you a beer!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm a fairly new Jira Agile user, so unsure - was this implemented? Michael's last comment was in 2012. tx in advance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes that is also exactly what I am looking for. Anyway of wresling this gadget out of you?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.