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

Question

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!

Trudy P Claspill · Answer

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:

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

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.

Lalarukh Mukhtar · Answer

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

Danut M _StonikByte_ · Answer

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.

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.

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.