Is there a gadget to sum numeric fields?

J Thomas
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.
August 31, 2011

For instance, if I have issues that have a 'Cost' or 'Man Days' field it would be great to have a dashboard gadget which displays the 'Total Cost' or 'Total Man Days' for all issues in my filter added together rather than listing the individual issues.

12 answers

2 votes
Mikkel Kragelund Nielsen
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 8, 2014
Bert Van Herck January 8, 2014

It probably does (stubled on that almost immediately after my previous post).

But now I'll have to upgrade our JIRA from 5.1 to something higher because it only works from 5.2 and up ... some scheduling to do.

Thanks anyway!

David Skreiner
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.
September 6, 2016

Plus, the plugin isn't free (otherwise people wouldn't need to spam for it), and you'd have all the usual problems with plugins (i.e. plugins not supporting a new version of JIRA which you need to install due to security issues).

abetit April 8, 2021

So its $900 to add things?

How much to divide?

Like Deleted user likes this
1 vote
Raimonds Simanovskis
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.
December 18, 2012

Please try eazyBI reports and charts plugin for JIRA - you can use it to create reports from totals of any custom numeric fields and analyze these totals by any standard JIRA fields as well as custom fields. Created eazyBI reports and charts can be published as JIRA dashboard gadgets as well.

Mikkel Kragelund Nielsen
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.
December 19, 2012

This is also what I have found to be the best solution. Other then having to learn MDX, it's pretty nice.

0 votes
Raman Bandarenka September 27, 2023

The only solution I found - is to calculate sum for the lookup issues set and put it to the separate field into definite ticket via automation rule. Using smth like

{ "fields" :
{ "customfield_10373" :
{{lookupIssues.customfield_10254.sum}}
}
}
0 votes
Tomáš Vrabec August 1, 2017

Hi there,

founded built-in solution.

Its a workaround, but its working.

1) Create JQL filter returning issues you would like to sum

2) Create dashboard

3) Add "Workload Pie Chart" Gadget

4) Set it for that created filter & estimations you would like to see.

Works for me

Ray Maxwell October 23, 2017

You need to read the original question they are looking to sum a field they created.  This plugin only sums time fields.

Like Cristiano Gomes likes this
0 votes
David Skreiner
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.
October 1, 2015

I uses ScriptRunner's JQL functions. 

For example, this one sums up all the values in the "word count" fields in unresolved issues in a test project.

project = TEST and resolution = EMPTY and issueFunction in aggregateExpression("total word count", "wordcount.sum()")



https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_aggregateexpression 

David Skreiner
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.
September 6, 2016

Unfortunately this previously free plugin is now very expensive, and the few useful elements aren't worth the insane price hike.

MAG-II August 28, 2019

Hello -

Is there a way to configure an aggregateExpression to display the sum of a number field?

0 votes
Deleted user September 23, 2015

Hi, 

You can use the Structure plug-in.

https://marketplace.atlassian.com/plugins/com.almworks.jira.structure

Is is quite pricey but but it is very powerful to get a broader view of a project and its progress. It allows you to build a hierarchy similar to Windows Explorer.

It has a handy Sum Up function that will sum up the value of a field for all issues under another issue hierarchically.

0 votes
Bert Van Herck January 8, 2014

Scripted fields work issue based, so not really helpful to do aggregated results accross issues (like sum of estimated working days per project).

2D filter also doesn't help because it's just summing up issues, not numeric field values.

eazyBI reports may very well solve the problem, but if you just want a gadget or two on the dashboard it's not really justifying the price tag. (I know, you get a lot more for that price, but if you don't need it you don't want to pay for it).

So my search continues ...

0 votes
Namita T December 18, 2012

I think you can use Scripted Fields.

https://studio.plugins.atlassian.com/wiki/display/GRV/Scripted+Fields

you can store the sum of two fields in a scripted field and that can be used in a 2D filter.

David Skreiner
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.
September 6, 2016

Unfortunately, that addon went commercial and is very expensive now.

0 votes
Kramarics György December 17, 2012

Hi Thomas!

We are using the script runner plugin. With that easy scripting solution you can get field values and sum them, and insert the new value into anther filed. I don't have better idea now. There is a lot of possibilities in this plugin:

https://marketplace.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner

Now, we are developing an own plugin, but before that it was really big help.

Gyuri

0 votes
Kramarics György November 8, 2012

Hi Thomas!

The two dimensional filter statistics can make totals, but I'm affraid you can't use all of your filds.
If I were You I would check it.

Gyuri

J Thomas
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.
December 17, 2012

Thanks Gyuri, I already use the 2D filter statistics a lot but it only counts the number of matching issues, it doesn't do anything to sum field values.

0 votes
Mikkel Kragelund Nielsen
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.
November 8, 2012

I'm also lokking for something to do this.

0 votes
J Thomas
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.
August 31, 2011

Or even something that list all the rows then displays a total?

Suggest an answer

Log in or Sign up to answer