Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Additional Field Options - Advanced Issue Filter on Dashboard

I'm trying to create a calculation based on the number of issues within a filter. For example, if I have 5 issues in Progress and 20 in "To Do" status, I'd like a formula that results in 25% of the tickets are in progress.

In the Advanced Issue Filter gadget, I don't see an Issue or Issue Count as Field Option. How can we bring in more field options? Where are these configured and how am I able to get a simple count of issues as a field within the defined variable section.

Thank you!



Welcome to the community @Anthony Bell 

 I usually recommend Custom Charts for Jira add-on as this allows you to do that. 

I think the internal filter only allows what you see. 

If you would like to to the app store and look for Custom Charts for Jira. You will get 30 days free. 

Like Marc Koppelaar likes this

This looked interesting so tried it. 

I think you need to select Count instead of Sum and then it counts the number issue in the filter. You don't need to select a field. 

Advanced filter.png

Open percent.png

@KJ I learned something new. Thank you for your replay and solution. 

Pls. try "2 dimensional filter statistics" widget to obtain total count against different status. This does not give information in percentage though.

You can use Issue Statistics in Dashboard .image.png

When you create and add a filter for this gadget, you will see the gadget picture below (Statuses wiil look like this)


Use the Pie Chart gadget and reference your filter, each section of the Pie will show the %. 

I am a big fan of the add-on "Rich Filters" for this type of thing. You can build a custom value and display it directly on your dashboard as a number. This is displaying different JQL-based categories, but it would appear visually the same:

Screen Shot 2022-08-11 at 1.29.31 PM.png


(I am not an employee of this vendor, just an aficionado of good reporting add-ons).


Log in or Sign up to comment

Atlassian Community Events