Only link Is Blocked by between projects

Questions & Answers
1

Hi Folks

This is a dependencies view table.

From left to right this show: issue with link “Blocks” with another issue, issue status, if the issue is flagged or not, flagged time and issue name that is blocked

This view shows issues from same project and another project. I need a help to show only issues in last colum that owns to another project.

I try this, but doesn’t worked:

Measure: Itens dependentes
Generate(
Filter(
– get a list of linked issues
[Issue].[Issue].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get(‘Blocks’)
),
– filter condition: include only issues from a different project
([Measures].[Issues created], [Issue].CurrentHierarchy.DefaultMember) <> [Measures].[Issues created]
),
– show by key
“[” || cast([Issue].CurrentHierarchyMember.Name as string) || "]
"
)

It’s possible?

Captura de tela 2024-01-19 101007
Captura de tela 2024-01-19 1010071569×683 49.4 KB

2

Hi Diego_Marcos_Ribeiro,
Thanks for reaching out to eazyBI community!
Try this formula for your calculation:

Generate(
  Filter(
  --get a list of linked issues
  [Blocks].[Blocks].GetMembersByKeys(
    [Issue].CurrentHierarchyMember.get('Blocks')
  ),
  --filter condition: include only issues from a different project
  [Issue].CurrentHierarchyMember.Get('Project key') <>
  ExtractString(
    [Blocks].CurrentHierarchyMember.GetCaption, 
    --return the first word 
    "^\w+")
  ),
  -- show by key
  '[' || cast([Blocks].CurrentHierarchyMember.Name as string) ||']'
)

This assumes that you have a dimension [Blocks]. Please adjust the formula if the precise name is different.

Let us know if that works for you or if you have more questions.

Kindly,
Ilze

1 Like
3

Hey @ilze.krauze

Wow, this worked very well

Thanks for help me

4

Ilze,

how can i show a column with the status of issue that is blocked ?

5

Hi,

since there can by several blocked issues, I would suggest adding status in the same column, like this:

Generate(
  Filter(
  --get a list of linked issues
  [Blocks].[Blocks].GetMembersByKeys(
    [Issue].CurrentHierarchyMember.get('Blocks')
  ),
  --filter condition: include only issues from a different project
  [Issue].CurrentHierarchyMember.Get('Project key') <>
  ExtractString(
    [Blocks].CurrentHierarchyMember.GetCaption, 
    --return the first word 
    "^\w+")
  ),
  -- show by key
  ' [' || cast([Blocks].CurrentHierarchyMember.Name as string) ||'] '||
  [Status].[Status].getMemberNameByKey(
    [Blocks].CurrentHierarchyMember.get('Status ID')
  ),", "
)

I hope this helps.

Best,
Ilze

1 Like
6

Thanks for help me

I tried this, but the that error occur

image
image1343×621 39.5 KB

7

Hi Diego_Marcos_Ribeiro,
Sorry for the trouble, there was a typo in the last formula. I edited it and it should work without errors now.

Best,
Ilze

8

Wow
Amazing @ilze.krauze
Thank you!