hello, we have a report that is displaying time on our epics. within this report we would link to display the parent link (initiative) name and a custom field (contact) name.
- Initiative Name
When i use the built in ‘issue portfolio initiative’ it displays the correct key, but i would like to display the name instead. i’ve tried to use [Issue].CurrentHierarchyMember.get(‘Initiative Name’) or [Issue].CurrentHierarchyMember.get(‘Portfolio Initiative Name’) but am getting no results.
- Contact (Custom FIeld)
On the Initiative, we have a custom field “Contact”. How would I display that value on the parent (Initiative) that is linked to the Epic?
Hi,
The recommended approach for this case is to access the initiative from epic using the GetMemberByKey function. Another function GetCaption is needed to have the full name of the Issue
The following formula gives the name of the initiative at the Epic level:
[Issue].[Issue].GetMemberByKey(
[Issue].CurrentHierarchyMember.get('Portfolio Initiative')
).GetCaption
Another, a bit shorter solution might work, but the result, in this case, is not limited to Epic Initiative level (it will show the parent name for each level):
[Issue].CurrentHierarchyMember.Parent.GetCaption
You can also apply pattern matching to extract only summary part of the parent issue caption:
ExtractString(
[Issue].CurrentHierarchyMember.Parent.GetCaption,
".+-\d+ (.*)",1)
Access to the parent’s property would be:
[Issue].[Issue].GetMemberByKey(
[Issue].CurrentHierarchyMember.get('Portfolio Initiative')
).Get('Some property')
Kindly,
Janis eazyBI support
Fantastic, works perfectly. Thank you very much Janis.