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

[Lalarukh Mukhtar]

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!

[Danut M _StonikByte_]

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.

[Trudy Claspill]

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]

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]

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.