Earliest Sprint start date rolled-up at Epic level

Questions & Answers
1

Hi again,

Given the below table, I try to get the earliest start date from filtered Issue Sprints at Epic level (and maybe above). Can someone please help me?

Important Notes: I filter the table by Time in Pages to control the timeframe presented:
image

I also filter specific Sprints with a MATCHES filter in Issue Sprints. I.e. Only Team A (TA) and Team B (TB) Sprints, while keeping (no sprint) for Epic issue type.
image

Hence we display the earliest Sprint the issue started within the Time set.

image
image868×143 5.35 KB

I get the earliest date from sprint with this measure:

Order(
    [Sprint].[Sprint].getMembersByKeys(
      [Issue].CurrentHierarchyMember.get('Sprint IDs')
  ),
  [Sprint].CurrentHierarchyMember.Get('Start date'),
  BASC
).item(0).Get('Start date')

Maybe this measure can also be enhanced to account only sprints where the issue has hours spent in sprint!? :slight_smile:

In advance, big THANKS!

2

Hi again MikeS!

If you name your calculation [Min start sprint date], then you can use the following formula to show it for epics or other upper levels. This time [Measures].[Hours spent] is used, therefore, report results will be limited to the issues where some hours are spent, and worklog start date is in the selected time.

TimestampToDate(Min(
  Filter(
    DescendantsSet([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Hours spent]>0
  ),
  DateToTimestamp([Measures].[Min start sprint date])
))

To filter sprints, do not use a row filter, but instead put Sprint dimension in Pages and select multiple values. Row filter only limits what is visible, not the data set that is used in calculations.

Let me know if that works for you or if you have more questions.

Best,
Ilze