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

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)

 

0 votes

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
Community showcase
Published 9m ago in Sourcetree

Tip from the team: configure your repos for hosting goodness!

Supported Platforms macOS Windows We recently introduced support for additional hosting services such as GitHub Enterprise, GitLab (Cloud, Community Edition, Enterprise Edition), and...

6 views 0 0
Read article

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