Find Questions…

Close ×
First time here? Check out the FAQ!

Is there a gadget to sum numeric fields?

J Thomas asked this question · 1,780 karma ·

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.

1843 views

J Thomas · 1,780 karma ·

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

Mikkel Kragelund Nielsen · 551 karma ·

I'm also lokking for something to do this.

6 Answers:

Mikkel Kragelund Nielsen · 551 karma ·

Maby this can do the trick: https://marketplace.atlassian.com/plugins/com.atlassian.cps.sumUp

Bert Van Herck · 1 karma ·

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!

Kramarics György · 121 karma ·

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 · 1,780 karma ·

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.

Kramarics György · 121 karma ·

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

Namita T · 16 karma ·

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.

Raimonds Simanovskis · 1,540 karma ·

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 · 551 karma ·

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

Bert Van Herck · 1 karma ·

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 ...

Looking for something else?

Find Questions…

or Browse other questions tagged:

or Ask a Question