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

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

Currently:

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

Solution:
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

Hi

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
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 Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

345 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