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.
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.
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"?
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.
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
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG