Show is blocked linked issues in table

Questions & Answers
12

@Jlf4EazyBi,
If you want to show URL to linked issues, then check this report: Stories by Epics with linked Bugs - Issues - eazyBI Demo Training - eazyBI and particulary measure “Linked bugs with status and hyperlink”. You need to copy the formula, adjust the dimension name and add the URL you have in your Jira:

-- annotations.group = 4 Issue links and hierarchies
Case 
When
  [Bugs].Currentmember is [Bugs].Defaultmember
Then
Generate(
-- get a list of linked issues
[Issue].[Issue].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get('Bugs')
),
-- show by key
"[*"||
cast([Issue].CurrentHierarchyMember.Key as string)
||"*](https://eazybi-training.atlassian.net/browse/"||cast([Issue].CurrentHierarchyMember.Key as string)||")"
|| " - " ||
-- show issue status
[Status].[Status].GetMembernameByKey(
[Issue].CurrentHierarchyMember.Get("Status ID")),
chr(10))
END

best,
Gerda