Counting project external blocking tickets

Questions & Answers
1

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!

2

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]
 ))
3

Hi @voi
You can try the following:

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

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.

image
image465×119 3.05 KB

Any Idea how to archive this? Thank you!

5

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:

image
image1508×825 78.4 KB

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

image
image832×835 54.9 KB

(7 instead of 2)

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

Thank You!

6

Hi @voi

You were going in the right direction with iterating. In this case, if you do not use Issue or Blocked by issues in rows, you need to iterate through both dimensions, because properties from both are used, and properties are available only on issue level.

However, this would be a very slow calculation.

Instead, I suggest creating a new JavaScript calculated custom field “Blocked by from another project” where you import only linked blocker issues from other projects (for instance, checking in the project keys of linked issues).
One example how to import all links: All Links

Ilze
support@eazybi.com