Get linked issue status

Hello,

We have created and imported a certain issue link. We now want to find the status of the issues linked via this link.

I’m using:

[Issue].[Issue].GetMemberByKey(
[Issue].CurrentHierarchyMember.get(‘Has to be done after’)
).get(‘Status ID’)

and unfortunately I am getting the status ID, instead of the name. I tried using "GetMemberNameByKey instead, but it gives me the following:

Formula is not valid:
No function matches signature ‘.get()’

Please let me know what’s wrong here.

Thank you!

Also, would it be possible to get each linked issue in a separate row?

Thank you!

[Status].[Status].getMemberNameByKey(
[Has to be done after].CurrentHierarchyMember.get(‘Status ID’)
)

and add the dimension representing the link in rows, after the ‘Issue’ dimension

1 Like