Not getting name of Last closed sprint

Questions & Answers
1

I want to show only the last closed sprint and used below MDX but I am getting last 5 sprints instead of only last closed sprint.

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)})

Kindly help in correcting above MDX.

Thanks
Murali

2

Hi @ramram4u

Please use this report to find our recommended formula for the last x closed sprints:
https://eazybi.com/accounts/1000/cubes/Issues/reports/50009-sprint-gantt-chart

In your case for very last closed sprint it would be the following code:

Aggregate(
Generate(
[Sprint].[Board].Members,
Tail(
Filter(
[Sprint].CurrentMember.Children,
[Sprint].CurrentMember.GetBoolean(“Closed”)),
1) --1 mean first member from a sorted tail
)
)

And there is one more report where you could filter the report sprints by board
https://eazybi.com/accounts/1000/cubes/Issues/reports/61946-sprint-velocity-chart

Martins / eazyBI support