Count linked issues

[Dustin Kalishoek]

We use Jira problems with linked incidents to them to keep track of how many incidents are logged for a specific problem.

And also to be able to close all of the affected incidents efficiently when the problem has been resolved.

An incident logged can be for one or more organizations.

How can I create a table containing all of the problems and counts of linked issues without having to create JQL for each single problem and organization combination?

I can pull the counts of linked issues required with (different versions of) below JQL, this works great to quickly lookup the different amount of linked issues on a single problem when asked.

linkedIssue in linkedIssues("issuenumber") and project = "project" and organizations = "organization" and resolution = unresolved

But having to do this manually for 80+ problems and 5+ organizations is way too much work and almost impossible to keep up-to-date.

What I am looking for is a table containing all problems with the following columns:

problem/issue number | total number of linked incidents to this problem | total number of unresolved linked incidents to this problem | total number of linked incidents for organization A to this problem | total number of unresolved linked incidents for organization A to this problem | etc. 

[Laura Campbell _Seibert Group_]

Hi @Dustin Kalishoek and welcome to Community.

I work with Brad Quirk, who is behind the app Dependency Mapper for Jira, which provides multiple options for displaying linked issues including a matrix or list view.

If you are open to adding an app to your instance, Brad would love to show you Dependency Mapper and generally learn more about your use case to get ideas for future features. You can book a call with him here.

[Jack Brickey]

Hi @Dustin Kalishoek , options:

• Addon app
• consider exporting to excel and leverage the built in capabilities
• connect your instance to PowerBI or similar