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.
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
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
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