Count issues by a field from a linked issue and drill through to source issues

Hi @PLaksh11 

@Habib__Plugio__ is correct.

You could look at Studio and with a good prompt you might be able to create such a gadget by creating a forge app.

But in 1st instance your question is a BI question, so your main option would be to get the data outside of Jira into a BI reporting tool like, PowerBI , Tableau or other.

This could be done via API or use 3rd party solution form the marketplace to export your data to such tools.

Hi @PLaksh11 ,

There's no native way to group or search Issue Type A by a field on its linked issues — JQL can't reach across links. The standard workaround is to mirror the field onto Issue Type A with Automation:

1. Create the same "Risk Category Level" select field on Issue Type A (e.g. "Risk Category Level (from B)").
2. Automation rule: trigger Field value changed (Risk Category Level, on Issue Type B) → branch For linked issues (your link type) → action Edit issue to copy the trigger issue's value into the mirror field. Add a second rule on the Issue linked trigger so newly linked issues get the value too.
3. For existing issues, run a one-time backfill (e.g. a Scheduled trigger with a JQL scope, then disable it).

Once the mirror field is populated, a native Pie Chart or Two Dimensional Filter Statistics gadget on a filter like issuetype = "Issue Type A" gives you exactly the Low/Medium/High counts, and clicking a slice/count opens the issue navigator with the underlying Issue Type A issues — that's your drill-through.

Hi @PLaksh11,

I don't see a way to achieve this using Jira's native functionality.

If you consider using an app, our Great Gadgets app can help.

It also offers a Work Breakdwon Structure (WBS) gadget that, when configured in Liked work items view, it can display the issues returned by a filter/JQL query (in this case "issueType = issueTypeA") together with their linked issues and relevant fields, such as Risk Category Level, like this:

If you use a certain link type for this, you can configure the gadget to display only those link types.

Danut.