I'd like to get a total sum of original estimate for issues (by filter condition) in a project that would do something like this:
SELECT SUM(originalEstimate) FROM ... WHERE project="Project Name" AND status IN("Resolved", "Closed");
Is something like this in any way possible from Jira? I managed to write a real SQL query to my MySQL database that gives me the result, but it's a bit clumsy compared to doing it from Jira.
founded built-in solution.
Its a workaround, but its working.
1) Create JQL filter returning issues you would like to sum
2) Create dashboard
3) Add "Workload Pie Chart" Gadget
4) Set it for that created filter & estimations you would like to see.
Works for me.
If you have ScriptRunner, this JQL query should show you the overall remaining workload for the current user:
project = PROJECT and assignee = currentuser() and issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()")
The documentation is here:
JQL is not SQL. It is exclusively designed for finding issues, it has nothing to say about the output (the line blurs slightly with the "order by" but that's actually still separate from what JQL does)
Think of it as two separate parts. You do the search in JQL, and that gives you a list of matching issues. That's all it does.
If you want to see that output, you have to hand that filter to a display mechanism. Jira has loads of these - broadly the issue navigator, gadgets, reports. The display mechanism then reads and formats the data on the issues in whatever way you want.
So, there's no way to do this in a JQL query, because JQL tells Jira nothing about the output. You need to find a reporting mechanism. Have a look at the issue navigator and the "sum" fields (prefixed with sigmas in the "add column" drop down list). The project reports might tell you something, as well as some gadgets. I suspect none of them will do quite what you want, as they're all generalised, and you may need to write something.
I just added a Chrome extension to the Chrome webstore that shows the summary of remaining estimates in Jira scrum boards, if you show the remaining estimates per issue: https://chrome.google.com/webstore/detail/estimations-sum-for-jira/mmbocjepfajlidapdnikdjebbdfjgbki
I can see this on the main dashboard as a option for adding a field, yet I can't write a filter showing the Sum of values. I'd love to say where sum(timeoriginalestimate) is 0, highlight these issues in my filter. I'm using with sub-tasks where the hours are actually estimated.
Any thoughts on how to fix would be ideal!
I have the same problem. How can I add these values and keep them "available" to make some calculations that I want to put in some reports?
Besides, the info I want to add is the total time spent by the issue, since its beginning until its closure.
As I have seen so far, the sumUp add-on adds only numeric fields.
Any help, please?
I ran into this problem a lot of times and decided to build a simple solution that works without any extensions:
=> Result: You get a popup window with the estimated remaining effort of the currently displayed issues.
I hosted the code on GitHub: https://github.com/dmstern/jira-hacks
Feel free to fork, star, contribute, share. :)
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events