Hi there
Currently we have measures to track efforts within portfolio epics e.g:
([Measures].[Hours spent with sub-tasks],
[Portfolio Epic].[LPMAZCH-202]
Now we want to track the efforts on epic level - therefore we have used 2 definitions:
([Measures].[Hours spent with sub-tasks],
[Issue].[APOLLO11X2-496])
or
([Measures].[Hours spent with sub-tasks],
[Issue.Epic].[APOLLO11X2-496])
However those definitions did not work and I do not see how I should define it. Please help:
Hi @JacksonKha
Welcome to the eazyBI Community!
There can be various reasons why no result is returned - without more information (report definition and some more details about the particular Epics), it is difficult to determine that.
However, from what I see, you are attempting to count only hours of particular Epics. Is that correct?
Potentially you might want to try aggregating in the Issue Type dimension all the issue types that are considered the children of Epics (and Epic issue type itself, if you’d like to include the Epic hours).
Here is an example of how aggregated member in the Issue Type dimension might look (learn more about calculated members here - Calculated members in other dimensions)
Once you have defined the calculated member, define a new calculated measure with the formula below and check if it returns the expected results. It will returns all logged hours for the issue types you define in the Issue type calculated member.
( [Measures].[Hours spent],
[Issue Type].[Children issue types] )
Best wishes,
Elita from support@eazybi.com
