Counting project external blocking tickets

Hello,

i try to count all unresolved tickets which are blocking a ticket in another project.
I used a lot of the scripts form this page:

and I guess i have to expand the filter in the “Linked Blocker(Bugs) Open” script to only include tickets if they are from another project

 NonZero(Sum(
    Filter(
      Descendants([blocked by].Currentmember, [blocked by].[blocked by]),
      IsEmpty([blocked by].CurrentHierarchyMember.get('Resolved at'))
      ) ,
    [Measures].[Issues created]
 ))
 

but i cannot seem to get it to work.
any suggestion would be appreciated!

This works for Project “DB”. Thank you. Now I need to find a way to generalize this for all projects. do you know a way to get the “key” for the current issue?

  NonZero(Sum(
    Filter(
      Descendants([blocked by].Currentmember, [blocked by].[blocked by]),
      [Blocked by].CurrentHierarchyMember.Name NOT MATCHES "CurrentProjectKey*" AND
      IsEmpty([blocked by].CurrentHierarchyMember.get('Resolved at'))
      ) ,
    [Measures].[Issues created]
 ))
 

Hi @voi
You can try the following:

InStr([Blocked by].CurrentHierarchyMember.Name, [Project].CurrentHierarchyMember.Get('DISPLAY_KEY'))

Thank you.

NonZero(Sum(
    Filter(
      Descendants([blocked by].Currentmember, [blocked by].[blocked by]),
      [Blocked by].CurrentHierarchyMember.Name NOT MATCHES 
      (ExtractString([Issue].CurrentHierarchyMember.Name,'([A-Z]{2,}-)', 1) || ".*")
      AND
      IsEmpty([blocked by].CurrentHierarchyMember.get('Resolved at'))
      ) ,
    [Measures].[Issues created]
 ))

worked.

But after a lot of different approachs i think what I actually need is some kind of
“Project blocking Project” Matrix.

Any Idea how to archive this? Thank you!

hello,

after hours of try and error i settled at this calculated member:

“Linked Blocked Extern”

  NonZero(Sum(
    Filter(
      Descendants([Blocks].CurrentHierarchyMember, [Blocks].[Blocks]),
      
      [Issue].CurrentHierarchyMember.get('Project key') 
         NOT MATCHES [Blocks].CurrentHierarchyMember.get('Project key')     
      ) ,
    [Measures].[Issues created]
 ))

This measure works:

unfortunately at issue level only :frowning: . if i aggregate at project level it calculates wrong:


(7 instead of 2)

any help to finaly fix the formula would be very appreciated.

Thank You!