Hi there,
I’m struggling to get the hours spent form my Epics’ child issues by Time context.
In Rows I have 3 dimensions:
- Issue – here I take a calculated member [Issue.Advanced Roadmaps].[Master Project]
- Country
- Advanced Roadmaps Epic
In Pages I have 3 dimensions:
- Time
- Logged by Team
- Project State
Total Hours Spent as Measure:
Sum(
Descendants([Issue].CurrentHierarchyMember),
[Issue].CurrentHierarchyMember.get('Hours spent')
)
+
nonzero((
[Measures].[Hours spent],
[Issue Type].[Epic]
))
This actually returns me all Epic’s child issues hours + Epic’s hours. but if I put Time as Page filter and select any period, it does not change anything but for the Epic’s hours.
Output sample:
-All Master Project | UK | Epic A | 10
-All Master Project | UK | Epic B | 5
-Master Project A | UK | Epic A | 150
-Master Project B | UK | Epic B | 100
1. I wish I could have only:
-Master Project A | UK | Epic A | 160
-Master Project B | UK | Epic B | 105
2. Instead of showing the total time, I need to show the total time depending on the timeframe selected with Time in Pages.
Any help much appreciated, thank you!