eazyBI report on open issues having a linked issue in specific project

[Christopher Krah]

Hi all,

I am looking to get a count per component of open issues
WHICH have a linked issue in project XYZ (one specific project, not all of the projects).

Right now, I have it set up with counts per category. Unfortunately these are all of the issues that have a link. How would I go about filtering these to only those issues that have a link to issues in the specific project XYZ.

Here is the field I added:

[jira.customfield_linked_issues]
name = "Links of issue"
outward_link = ["is related to","relates to","is blocked by","blocks"]
dimension = true

and I have added that as a dimension to columns.

I'm guessing I need to create a new calculated measure in which I will filter on the  "Links of Issue" field. I'm not sure though how to. It would be great if somebody can point me in the right direction. 

Thanks

[Fabian Lim]

Hi @Christopher Krah

The measure would be something like this. 

[Issue].[Issue].GetMemberByKey(
  [Issue].CurrentHierarchyMember.get('My link')
).get('My property')