Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Is there a way to count/total a number field of multiple issues in a filter or roadmap?


For example, I have a field called '# of Apps' in the issue type of Initiative (some have 1, another might have 6 or other). Can I get a sub-total, total, sum, or count of the number in this field for all Initiatives to display in a filter or roadmap? So if I have 6 Initiatives with a total of 15 from the # of Apps field, how can I show this?

4 answers

1 vote
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 20, 2023

Hello @Wendy Benson 

Welcome to the Atlassian community.

It does not appear that the Roll-up option in the View Settings for an Advanced Roadmap plan will roll up a custom field.

You could use Automation Rules to automate updating the field in parent issues as it changes in child issues. If the data is stored in the Initiatives then you can display the field in Plans and in the results of Filters.

Thanks, Trudy -- I'm not looking for a roll-up from child issue to parent issue -- I'm looking to sum a field in all Initiatives

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 23, 2023

Hello @Wendy Benson 

Thanks for that clarification. 

I am not aware of a method to display a sum like that in the Advanced Roadmaps Plan.

Nor am I aware of a way to show a sum of values from selected issues directly as part of the output of a search/JQL, nor a native Dashboard gadget for doing that.

You could use an Automation Rule to search for the issues (Lookup Issues action) and mail the sum/total to yourself and others (using the smart value {{lookupIssues.your Apps field name.sum}} )

Thank you, everyone. I Figured out a way to use the Jira Dashboard with my filter and sum the field by Status.

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Oct 23, 2023

Hi @Wendy Benson

if you're open to solutions from the Atlassian, I think you'd like the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for configurable sum-ups. With sum-ups, a view like the one below can be built in just a couple of clicks:


Note that this doesn't require any scripting or automation whatsoever; you just create a sheet with your initiatives, enable the sum-up feature, and that's it. This will also work nicely together with JXL's many other advanced features, such as support configurable issue hierarchies, issue grouping by any issue field(s), or conditional formatting.

Any questions just let me know,



0 votes
Danut M _StonikByte_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 21, 2023

Hi @Wendy Benson,

You can do this by using the Issue Filter formula or the Advanced Issue Filter Formula gadgets offered by our Great Gadgets app.

These gadgets can apply a math formula ('SUM' , 'COUNT', 'MIN', 'MAX', 'AVERAGE') against the numerical field ('# of Apps' in your case) against the issues from one to more filters. 



All you have to to do is to create a filter (or more) that return the issues to be counted and to configure the gadgets to use the filter(s).

Please note that this app offers many other gadgets that you will find useful. Just have a look over the articles from our blog to make an idea. It can be a great asset for your team and company.

I hope this helps. 


Thank you, Danut -- I will pass this on to our Jira Sys Admin to see if we can add an app -- I was hoping there might just be a way in JQL to do this without add'l apps

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events