Aim:
To easily calculate the sum of original estimates in a filtered set of issues.
Currently:
Solution:
Is there anything JIRA can do to vastly improve what seems to be a trivial task?
If you want to do this in Excel, use the Better Excel Plugin. You can easily define an Excel template that makes step 3,4,5 automatic for you. (Tip: use the SUM() function for the calculation, and a formula for the conversion.)
If you want to do this right in Issue Navigator, you could also try the SumUp plugin.
Thank you for introducing SumUp! :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you have Script Runner installed, you can use Aggregate Expressions in JQL:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I think JIRA do every thing based on Issues and your calculated filed doesn't belong to any issue.
I suggest this trick
and use Script Runner plugin for doing this!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Damian.
That does summarize the duration left in "x weeks y days z hours".
I wanted a total "hours" figure for this, but each company will have a different figure for how many hours equates to 1 day, etc.
In the meantime, its copying that "x weeks y days z hours" into another spreadsheet (lol) that I've configured to give me a total hours figure. I know I could get someone to look at the code in our settings, I'll get to that sometime in the future.
Still, a win (and cut in time spent) compared to the previous steps. Cheers for your help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.