voi
May 30, 2025, 1:07pm
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!
voi
May 30, 2025, 2:22pm
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]
))
Hi @voi
You can try the following:
InStr([Blocked by].CurrentHierarchyMember.Name, [Project].CurrentHierarchyMember.Get('DISPLAY_KEY'))
voi
June 2, 2025, 9:24am
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.
Any Idea how to archive this? Thank you!
voi
June 3, 2025, 2:47pm
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:
unfortunately at issue level only . 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!