Gadget for Total count of open vs closed tickets for Multiple projects

Lalarukh Mukhtar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 26, 2024

How do we get a Total count of open vs closed tickets for Multiple projects. I am trying to get the answer as a summary with all selected project counts combined as a high level count of 1 number for total open tickets, 1 number for total closed tickets. Is there a gadget on dashboard that can help with this or if there is a way to customize for this view. Thank you!

2 answers

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.
February 26, 2024

Hi @Lalarukh Mukhtar,

This can be easily done by using the gadgets offered by our Great Gadgets plugin.

This display this info as numbers, your could use the Issue Filter Formula gadget, or the Advanced Issue Filter Formula gadget. This gadget allows you to display percentages and other metrics.

image.png

All you need to do is configure this gadget to calculate COUNT on a filter that returns open tickets for all projects and a filter that returns closed tickets for all projects respectively.

If you want this in form of a chart with timeline, you could use the Cumulative Flow Diagram chart offered by the same app.

image.png 

See also: https://community.atlassian.com/t5/App-Central/How-to-track-scaled-agile-SAFe-projects-in-Jira-with-Great/ba-p/1929694

Hope this helps.

Danut.

0 votes
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.
February 26, 2024

Hello @Lalarukh Mukhtar 

Welcome to the Atlassian community.

Are you trying to get that data for a single point in time, such as "today there are a grand total of X tickets that have been created in these projects and of those Y tickets are currently closed"?

What is the range of the number of issues you expect to have? Less than 1000? Less than 5000? More than 5000? More than 10,000?

You could use the Created vs. Resolved gadget on the dashboard, but you would need to create a saved filter that specified the projects to include and the earliest possible creation date for an issue. However, there may be a limitation on how many issues could be retrieved for that gadget.

Lalarukh Mukhtar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 27, 2024

Thank you, I am looking for a single number count as an aggregate sum of all the projects.

The expected number may be more than 10K

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.
February 28, 2024

If you want a solution that does not require an app, and you are okay with getting a chart display rather than simply the totals, you can indeed use the Created vs. Resolved gadget.

You can create a filter that will retrieve the total issues you want to report. You won't be able to see all those issues in the View all issues screen because that screen is limited to displaying 1000 issues.

Within a Jira Dashboard you could then add the Created vs. Resolved gadget, and have it use the filter you created.

If you configure it thus:

Screenshot 2024-02-28 at 5.04.02 PM.png

 

...you will get a chart like this with the last data points being the current totals.

Screenshot 2024-02-28 at 5.05.12 PM.png

 

 

I configured the chart to use 5300 for Days Previously. That means it will count every issue created and every issue resolved in the past 5300 days (20 years). You would need to set that value far enough back to reach the earliest Created date for the issues in your filter.

Note that this chart is based on the Resolution field having been filled in, which sets the Resolved date. If your Jira instance was configured in a way that your completed issues were not getting their Resolution field filled in, then this report would not be accurate.

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events