How to get the sum of a field across thousands of issues?

Question

I have about 1000 issues that have a field named "Number."  I want to find the sum of the Number field across all 1000 issues.

Example:

* Issue 1: the Number field is set to 250
* Issue 2: the Number field is set to 400
* Issue 3: the Number field is set to 50

So the number I would be looking for is 250+400+50 = 700

Alex Koxaras -Relational- · Answer

Hi @Jason Freeze and welcome to the community,

You can use Jira Automation to do that. I wrote an article a while ago about how to sum a field to an epic. The thought is simple: use lookupIssues smart value via Jira automation to do that. After that you can either log the result, or place the result on an issue field. Read this for starters https://community.atlassian.com/t5/Jira-Software-articles/Calculate-the-sum-of-original-estimates-of-all-issue-types-to-an/ba-p/1660572

Joseph Chung Yin · Answer

@Jason Freeze -

Welcome to the community.  Out of the box, you will need to construct a JQL query to obtain all the issues and add your Number field as a result column.  Afterward, you can export the results into a CSV file and use Excel to conduct the summation.

NOTE - There is a default on # of issues that one can export, here is the workaround (even it is tagged for Jira Cloud env, but it will work for the Server env) - https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html

Otherwise, you will need to acquire third party add-on to support the result export or generating the reports of of your JSM content by searching for add-ons via the MarketPlace (https://marketplace.atlassian.com/)

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.