How to get the parent issue type of a subtask

hi ,

I am configure a report that require a measure that return parent issue type, when issue type is subtask.

Create a new calculated measure in Measure dimension with this formula,but is not work,it’s display is empty.

Measure one:
[Issue].CurrentHierarchyMember.Parent.get(‘Type of Issue’)

the other one:

[Issue Type].[Issue Type].getMemberNameByKey(

[Issue].CurrentHierarchyMember.Parent.get(‘Issue type ID’))

question

can you help me to resolve this??

Thank’s

Hi @xixila

Try this formula for parent issue type calculation:

[Issue Type].[Issue Type].getMemberNameByKey( 
[Issue].[Issue].GetmemberByKey(
[Issue].CurrentHierarchyMember.Get('Parent issue key')).get('Issue type ID')
)

Martins / eazyBI support

This is a good method , thanks very much.

@Marcelo_Ignacio_Cid1

Do you want to filter issues by their own status or by their parent status?
Why would you use Parent issue key to filter them?

If you want to filter issues that are in status (their own status) Done, you can use this tuple structure:

(
[Measures].[Issues created],
[Status].[Done]
)

Martins / eazyBI team