I have a report that shows % resolved for Advanced Roadmap Initiatives. I am including a custom field for ‘epic t-shirt size’ as a dimension. I see multiple rows for epic t-shirt size, showing the % resolved for each relevant value of epic t-shirt size. How do I show the current value of epic t-shirt size, with the total % resolved, including when epic t-shirt size was different.
Hi @JCJC,
Using T-shirt size as a dimension groups issues for the relevant T-shirt size throughout the hierarchy.
You might use the property ‘Issues T-shirt size’ as a measure to show the current value for the issue.
However, if you want to display the current T-shirt size of the Epic level for all its underlying issues - you might use a calculated measure similar to this to retrieve it from the Epic level.
Ancestor([Issue.Epic].CurrentMember, [Issue.Epic].[Epic]).Get('T-shirt size')
Regards,
Oskars / support@eazyBI.com