To be able to select the current active sprint and the last closed sprint

Questions & Answers
1

Currently, I manually select the last closed sprint and the current sprint (for instance sprint 10 (current active sprint and sprint 9 ) via Sprint > Bookmarked members > search current sprint and last sprint.

Is there a way to automate this? Kindly let me know

Thank you

2

Hi,

Yes, it is possible to create a calculated member in the Sprint dimension to find the last closed sprint and the closest uncompleted sprint. The formula provided is a bit more universal; you can adjust the number of last closed sprints and number of uncompleted sprints in it:

    Aggregate(
    {
    Tail(Order(
    Filter([Sprint].[Sprint].Members,
    [Sprint].CurrentMember.getBoolean('Closed') AND
    NOT IsEmpty([Sprint].CurrentMember.get('Complete date'))),
    [Sprint].CurrentMember.get('Start date'),
    BASC
    ),1),--number of last completed sprints by complete date
    Head(Order(
    Filter([Sprint].[Sprint].Members,
    NOT [Sprint].CurrentMember.getBoolean('Closed') AND
    NOT IsEmpty([Sprint].CurrentMember.get('Start date'))),
    [Sprint].CurrentMember.get('Start date'),
    BASC), 1) --number of closest uncompleted sprints by start date
    }
    )

Kindly,
Janis eazyBI support

3

Hello Janis. I was trying to use this formula but I get a Lexical error when trying to save it. Do I need to make any adjustments? Lexical error at line 5, column 35
image
Thanks,
Thayne Munson

4

Hi @thaynemunson ,

Sorry for the trouble. The code in the post had corrupted quotes. It should be fixed now.

Kindly,
Janis, eazyBI support