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 vote

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Trello

Get inspired with Trello & earn free Gold

A blank Trello board can be both a beautiful and intimidating thing. How many lists should I have? Is creating 10 labels overkill? How can I best track my progress? Is there a way...

29 views 0 3
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