How get parent issue type

hi there,

I am configure a report that require a measure that return parent issue type.
I use below calculated member formula, but is not work.

[Issue].CurrentHierarchyMember.Parent.get('Type of Issue')

can you help me to resolve this??

Thank’s
Azadeh

Hi @azade_bagheri !

We have predefined issue property in eazyBI what is called Issue type that will return issue type for the selected issue. And based on the same formula we can adjust it and create a new one called Parent Issue type.
Create a new calculated measure in Measure dimension with this formula:

[Issue Type].[Issue Type].getMemberNameByKey(
  [Issue].CurrentHierarchyMember.Parent.get('Issue type ID')
)

this will return issue type for sub-task’s Parent

Gerda / support@eazybi.com

1 Like

Hello Gerda,

My problem is solve.

Thank’s

1 Like

Hello Gerda,
I’ve created the calculated metric “Parent issue type” exactly as you indicated, but I can’t see any info there.
What could the problem be?

Hi @glando,
it is hard to tell why this doesn’t work on your report as this solution is still valid and working. You can check is there isn’t any typo in your code or you can send email to us directly with your report definition.

best,
Gerda // support@eazyBI.com

@gerda.grantina
Is it possible to obtain the resolution date of the father?
For example in the task demo-18, get obtain the resolution date the bug demo-16

@Marcelo_Ignacio_Cid1 ,
Yes, you can do it with this formula:

[Issue].CurrentHierarchyMember.Parent.get('Resolved at')

Don’t forget to apply “Date / Time” measure formatting to show date.

best,
Gerda

1 Like

Oh thank you so much @gerda.zandersone :smiley:

Does this measure work with that category?

image