Sum field for reporter

[german]

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

[Nicolas Werle _Decadis AG_]

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)

[Aron Gombas _Midori_]

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.