Count linked issues

Dustin Kalishoek
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!
July 8, 2024

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. 

 

 

2 answers

0 votes
Laura Campbell _Seibert Group_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 9, 2024

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.

0 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 8, 2024

Hi @Dustin Kalishoek , options:

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events