Sum field for reporter

Question

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

Aron Gombas _Midori_ · Answer

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.

Nicolas Werle [Decadis AG] · Answer

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)