I need to add all the remaining hours (remaingEstimate) that users have in their assigned tasks per week.
That is to say in this week how many hours a user is assigned to know if they can be assigned more.
Example of a week (L-D):
Pepe 4 tasks 20 hours
Lucia 8 tasks 33 hours
sumUp for JIRA helps you to get the sum or average value of your custom or system field columns in the issue navigator and on your dashboard (based on a filter).
You can e,g, sum up the estimated time and remaining time of optional tasks.
If you have any questions, please feel free to contact us via e-mail: atlassian-support(at)decadis(dot)de.
With best regards
Basically run the JQL search that generates the issues to report on, then run the result through a custom Excel template. The template should generate the issue list to a worksheet, particular the reaminingEstimate field, then aggregate these to a pivot table where assignee is the main dimensions.
Then use the Excel Automation add-on to send this to you each week.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot