Support with advanced filter/graph

[Jonathan Warwick]

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?

[Pasam Venkateshwarrao]

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

[Luka Hummel - codefortynine]

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