Get Sprint based on date in time dimension

Questions & Answers
1

I want to create a matrix showing future sprints for each board based on a date.
With time showing dates (daily) from today to 52 weeks from now in the Row section and Sprint (board) in the Column section. I would then need a calculated measure that would find the sprint scheduled for the date in the row section for the boards in the columns section.

Like this:

Matrix
Matrix860×538 165 KB

Any help you can provide on the calculated member I’d need to get the sprint would be greatly appreciated.

2

Hi @Shel_Price,
Here is a formula that is taken from this report for Versions: Versions on Timeline - Issues - Jira Demo - eazyBI

You can adjust the formula for Sprints:

Generate(Filter( 
    [Sprint].[Sprint].Members,
  DateInPeriod(
    [Sprint].CurrentMember.get('Start date'),
      [Time].CurrentHierarchyMember
    ) AND ([Time].CurrentHierarchy.DefaultMember,
      [Measures].[Issues created]) > 0),
  -- show sprint name
  [Sprint].CurrentMember.Name,
  ', '
)

By default, eazyBI is adding members to the Time dimension only if there is some activity on that date. Future dates often are not added as the only action that usually is in the future is the Issue due dates or Sprint start date. Nevertheless, if you would like to add projection in the future or fill in gaps for the past, you can add members to the Time dimension manually.
See details here Create reports - eazyBI

Kind regards,
Gerda // support@eazyBI.com