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

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.

5 answers

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

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"?

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.

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

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

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

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

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

1 vote

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 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,731 views 17 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you