I want to sum up values of a created custom field.

[Peter Wrzos]

I am trying to do some basic reporting. I created 2-D gadgets that list number of issues based on categories. I want to do the same but instead of one of the categories, I want to sum up values on a custom field. E.g. instead of having a 2-D filter telling me how many Xs, Ys and Zs are Closed, Resolved or Opened, I want to sum the value of a custom field per category X, Y and Z.

Please help.

[David Skreiner]

Unfortunately ScriptRunner (which used to be free) is very expensive now.

Is there a free addon that allows us to add up all the numbers in a certain field, e.g. "planned effort for this sprint" or "overall costs for all these Marketing issues"?

[EddieW]

I suggest Jamie's Script Runner plugins that includes custom JQL function "aggregateExpression"

just add something like

and issueFunction in aggregateExpression("Label to show",fieldTo.sum)

to your filter/search. And you will get a small alert box with the outcome.

https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-AggregateExpressions

[Juliano Acauan]

This worked fine for me. I needed to add Story Points and used storyPoints.sum().

[petry]

Maybe the Better Excel Plugin for JIRA can be an option for you:

http://www.midori-global.com/products/jira-better-excel-plugin/documentation/formulas

Cheers,
Andre 

[JulianA]

Hey,

we recently released a plugin that calculates totals... You might want to check it out:

https://marketplace.atlassian.com/plugins/com.atlassian.cps.sumUp

Cheers

Julian

[Rita YOUNES [Infosysta]]

Hello @Julian Riedinger [Decadis AG] Can we Calculate Sum of Custom Field by user in your plugin?

[Julian Riedinger [Decadis AG]]

Hi Rita, with the current version of our SumUp add-on you can enter any jql query you like in your issue navigator, select a configured column with summarizable values and with a little click on the calculate button, you get the calculated totals. Unfortunately JQL has no 'group by' feature. But i have great news for you! We are currently implement a SumUp Gadget, where you can easily sum up values and grouping the results by any issuefield you like. Maybe you are interested in trying the beta? Cheers Julian

[Rita younes]

Hello @Julian Riedinger [Decadis AG] , Yes am really interested to try this features.how shall we proceed ? Thanks

[Julian Riedinger [Decadis AG]]

Hey Rita, I think the easiest way is to write a mail at j.riedinger [@] decadis.de, so I can provide you a link to the beta version Cheers Julian

[Onkar Ahire]

JIRA Misc Custom Field plugin might be helpful for you.

https://innovalog.atlassian.net/wiki/display/JMCF/JIRA+Misc+Custom+Fields#JIRAMiscCustomFields-calculatednumberfield

Regards

Onkar Ahire

[Peter Wrzos]

Hi,

My question was misunderstood. I have a number field across a certain issue type. I want to sum up all the values of this field for all the issues. E.g. I have an issue type called 'work day' - one of the fields part of this issue type is 'no.of.hours'. I want to sum up all 'no.of.hours' for all the 'work day' issues. The summed up value is not a field - thus a calculated field will not do. All I want to do is to display this sum in a 2-d Filter, a report, etc.

Thanks,

Peter.