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:
So the number I would be looking for is 250+400+50 = 700
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.