Is there an easier way to calculate sum of original estimates?

To easily calculate the sum of original estimates in a filtered set of issues. 


  1. Search using filter
  2. Export to excel
  3. Format (unmerge cells)
  4. Sum 'Original Estimates' column
  5. Convert to hours

Is there anything JIRA can do to vastly improve what seems to be a trivial task? 

4 answers

If you want to do this in Excel, use the Better Excel Plugin. You can easily define an Excel template that makes step 3,4,5 automatic for you. (Tip: use the SUM() function for the calculation, and a formula for the conversion.)

If you want to do this right in Issue Navigator, you could also try the SumUp plugin.

Thank you for introducing SumUp! :)

Thanks Damian.

That does summarize the duration left in "x weeks y days z hours".
I wanted a total "hours" figure for this, but each company will have a different figure for how many hours equates to 1 day, etc.

In the meantime, its copying that "x weeks y days z hours"  into another spreadsheet (lol) that I've configured to give me a total hours figure. I know I could get someone to look at the code in our settings, I'll get to that sometime in the future.

Still, a win (and cut in time spent) compared to the previous steps.  Cheers for your help


I think JIRA do every thing based on Issues and your calculated filed doesn't belong to any issue. laugh

I suggest this trick wink

  • Create New Project
  • Create a fake Issue - I suggest to name it project static data od something else
  • Create a calculated number filed(F1) and use your company conversion rate for week to day and day to hour. and put this in your main projects issue
  • Create another calculated field and put it in your fake issue and show the sum of (F1)
  • You can use other fields and reserve this project just for showing some aggregated data of all your organization projects.

and use Script Runner plugin for doing this!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,076 views 4 9
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