Sum field for reporter

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

2 answers

This widget could not be displayed.

Hey, 

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

Nicolas Werle

(Decadis AG)

 

This widget could not be displayed.

Better Excel could do this for you using a regular Excel pivot table.

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.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

115 views 2 0
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you