Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,368,008
Community Members
 
Community Events
168
Community Groups

How can I report on linked tickets?

Our incidents are being managed in an independent project (i.e. not in individual team projects/workflows etc)

When managing incidents a number of continuous improvement tasks have been linked to the 'causing' incidents.

Is there a way to filter/report on tickets in a project with linked tickets?

 

I'd love to export and see how many incidents bore improvements within different sectors.  

4 answers

4 votes

@Charlotte Bish 

You can export Jira issue links to Excel with Better Excel Exporter for further analytics and reporting of linked issues.

The app comes with a dedicated template for this use case and produces an Excel export like this out of the box (can be customized):

jira-issues-with-issue-links.png

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

3 votes

Hi @Charlotte Bish 

If you export your Jira issue from Issue navigator to CSV/Excel then you will find a column called "Links" which is "Linked issues".

You can also use a JQL like this.

issue in linkedIssues("TMPS-7", blocks)

 There are some apps that can give you a visual report like Structure.

I hope it helps.

Ravi

1 vote

Hi @Charlotte Bish,

As @Ravi Sagar _Sparxsys_ mentioned, you can absolutely use Structure to view and report on linked tickets.

Structure allows users to visualize default parent-child relationships in Jira (for example :epic > story > sub-task), but its real power is in its ability and flexibility to visualize any other issue links between stories, tasks, and other issue types in an organization.

It also allows you to add any Jira field as a column, so that pull all your work together in one spreadsheet-like view (e.g. for release planning, backlog grooming, or in your case, reporting on "causing incidents").

Structure can also sum up values in any column that contains numeric values, like Story Points and Estimates. Here's Structure in action with a 5-level hierarchy that uses a "Linked Items" rule:

structure-5-level-hierarchy-generators.gif

I'm part of the Structure team and wanted to expand on what was mentioned – hope this helps!

Best,
Kathryn

0 votes
Rahul_RVS_Support Marketplace Partner Aug 12, 2022

Hi @Charlotte Bish 

If you are fine with a mktplace app, you can have a look at our add-on to get this data.

Issue Hierarchy Reports 

and generate insights such as:

- View the full Jira Issue Type hierarchy of Linked issues,
Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

- % complete based on time spent and story points at each hierarchy level

- Sum up Time Spent, Org Estimate, Time Rmng, custom number
fields

The app allows you to add your custom fields on the report screen.

 

Links HIerarchy.PNG

Suggest an answer

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

Atlassian Community Events