Sprint goals per sprint between dates (for a release)

Questions & Answers
, , ,
1

Hi,
I am trying to create sprint goals report per sprint for a release. We release every quarter.
So, for example if the release is between Jan 1st and Mar 31st

Board| Sprint goal | Start Date | End Date
A | abc |01/01/2020|01/14/2020
A |xyz |01/15/2020|01/28/2020
…
…
A |fg |03/18/2020|03/31/2020
B |cde |01/01/2020|01/14/2020
B |fsa |01/15/2020|01/28/2020
…
…
A |fgds |03/18/2020|03/31/2020
So far, I have “All Sprints” selected on the Rows, “Sprint Goals” selected under Measures and displays for all the boards. How do I limit to show only sprints between a date range and limit to only boards A, B and C?
Thank you

2

Hi @jkrishnan,
welcome to eazyBI community! :slight_smile:

About your question - you may want to check our demo account where in the Sprint dimension you can find a calculated member Sprints closed between two dates. This measure shows you all sprints that have been completed between specific dates. You can change them accordingly to your needs.

Aggregate(
  Order(
    Filter([Sprint].[Sprint].Members,
      [Sprint].CurrentMember.getBoolean('Closed') AND
      NOT IsEmpty([Sprint].CurrentMember.get('Complete date')) AND
      DateBetween([Sprint].CurrentMember.get('Complete date'),
        '01 JUL 2016',
        'today') ),
    [Sprint].CurrentMember.get('Complete date'),
    BASC
  )
)

best,
Gerda // support@eazybi.com