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

Question

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

Currently:

* Search using filter
* Export to excel
* Format (unmerge cells)
* Sum 'Original Estimates' column
* Convert to hours

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

Ansar Rezaei · Answer

Thank you for introducing SumUp! :)

Midori · Answer

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.

Ansar Rezaei · Answer

Hi

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

I suggest this trick

* 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!