Roll up sprint start and end dates from stories to epic on gantt chart

Questions & Answers
1

I’d like to create a gantt chart on epic level where I can see the start date of the earliest sprint and the end date of the latest sprint assigned to stories under this epic. Is there any solution for this

2

Hi,

Welcome to our community!

The dates can be found with custom calculations. Assuming that you use the Epic in the report rows, the following formula gives the date of the earliest sprint for the epic:

Head(
  Order(
  Filter([Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name<>"(no sprint)"
  AND
    [Measures].[Issues created]>0),
    [Measures].[Sprint start date],
    BASC
  )
).Item(0).Get('Start date')

The end date of the latest sprint:

Tail(
  Order(
  Filter([Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name<>"(no sprint)"
  AND
    [Measures].[Issues created]>0),
    [Measures].[Sprint start date],
    BASC
  )
).Item(0).Get('End date')

Kindly,
Janis, eazyBI support

3

Thanks a lot. I think it’s working. Previous formula I tried to use was timing out

1 Like