How to show Advanced issue hierarchy based on closed date for highest level

Questions & Answers
1

Hello,

I have an Advanced Issue hierarchy
Saga-Epic-Story
I would like to create a report to see Story Points on every level
for closed Saga
Page Filter: Time (Quater), Project
Row - Issue (selected Advanced Issue hierarchy - Saga)

The problem is stories and epics that are under Saga can be completed in different Quater

please, How to manage it?

Thank you ahead
best regards,
DKostiuk

2

Hello @DKostiuk ,
You can try this formula to calculate Story Points by Saga resolution date.

CASE WHEN
--calculation at Advanced Roadmap all level
  [Issue.Advanced Roadmaps].CurrentHierarchyMember.Level.Name = "(All)"
THEN
Sum(
  Filter(
    DescendantsSet(
      [Issue.Advanced Roadmaps].CurrentHierarchyMember, 
      [Issue.Advanced Roadmaps].CurrentHierarchy.Levels("Saga")
    ),
-- Saga resolution date in period
    DateInPeriod(
      [issue].CurrentHierarchyMember.Get("Resolved at"),
      [Time].CurrentHierarchyMember
    )
  ),
-- counts Saga Story points resolved (including the children) and ignores the resolution date
  ([Measures].[Story Points resolved],
  [Time].CurrentHierarchy.DefaultMember)
)
WHEN
-- calculation at lower levels in AR hierarcy
  [Issue.Advanced Roadmaps].CurrentHierarchyMember.Level.Name <> "(All)"
  AND
  --checks that Saga resolution is in the selected time period
  DateInPeriod(
      Ancestor([Issue.Advanced Roadmaps].CurrentMember,[Issue.Advanced Roadmaps].[Saga]).Get('Resolved at'),
      [Time].CurrentHierarchyMember
    )
THEN
--count story points resolved in any period  and ignores the resolution date
  val(([Measures].[Story Points resolved],
  [Time].CurrentHierarchy.DefaultMember))
END

best,
Gerda // support@eazybi.com