Filtering by Issue Links

Questions & Answers
1

in my Jira structure, we have Features created that have a Related Requirement as an issue link.

i am trying to filter out Features that do NOT have a Related Requirement as an issue link. Is this possible in eazybi?

2

@martins.vanags Any advice you can help with on this filtering inquiry would be much appreciated.

3

Hi @Mark_Z ,
If you have imported “Related Requirement” as the issue link dimension then one of the quickest ways how to filter issues by their NOT linked requirements is using row filtering for issue property "Issue Related Requirement" not matches .
See an example:

image
image2070×652 53.8 KB

Another option is to create a new calculated measure using this formula:

Sum(
  Filter(
    DescendantsSet(
      [Issue].CurrentHierarchyMember,
      [Issue].[Issue]),
      [Measures].[Issues created]>0
      AND
      IsEmpty([Measures].[Issue Related Requirement])
  ),
  [Measures].[Issues created]
)

best,
Gerda // support@eazybi.com