Support with advanced filter/graph

Question

Details:

I have 2 projects I am working with, lets call them Project 1 and Project 2.

Project 1 tickets are linked by "Relates to" to project 2

Project 2 has tickets of which the subtasks track work required with 2 statuses (to do, Done)

I want to create a graph in a dashboard which shows the various ticket numbers from Project 1 (e.g **-123) has x number of subtasks still "to do" in related project 2 ticket

Any idea of how to do this?

Luka Hummel - codefortynine · Answer

Hi @Jonathan Warwick and a belated welcome to the community!

If you are willing to use a third party app, you can try our app Dynamic Custom Fields for Jira. With Dynamic Custom Fields, you can use Jira Expressions to have automatically updating custom fields that you can use for other things like having them displayed in your Jira Dashboards.

The following Jira Expression should generate the number of linked related issues that are still in the "To Do" category.

issue.links.filter(l => l.type.name == "Relates" && l.linkedIssue.status.category.name == "To Do").length

Pasam Venkateshwarrao · Answer

Hi @Jonathan Warwick

Yes this can be possible through EazyBi Plugin

For reference you can check the below link

Stories with Bugs details - Issues - eazyBI Demo Training - eazyBI