Board-related reports with multiple projects and multiple boards

[Mauro_Bennici]

Greetings,
I’m trying to set up a performance dashboard, and I’m struggling with hierarchies.
As long as I had one project, no problem.
Since I loaded more data (multiple projects, multiple boards), nothing worked anymore.
I’m trying to understand how I can calculate the last closed sprint in a board, because the calculated dimension I’m using seems to work only with a single board in sight, otherwise it keeps giving me the last closed sprint - in general - not related to the board I’m watching.
Help pls.

This is the calculated dimension:

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

[martins.vanags]

Hi @Mauro_Bennici

Perhaps you will find this post useful to calculate results for last closed sprints in the board.
Try exploring the calculated measure and how to adjust it for your report.

Filter your eazyBI for last 5 closed sprints

Hi This is an approach on how to filter the report for the last 5 closed sprints if you have other dimensions in pages which makes the report context. You could adjust the code to show more/less than 5 and also switch to show first sprints by changing the ordering conditions. First, you could create a new calculated measure (only to filter last 5 closed sprints sorted by sprint start dates) in your report using this code: Case when [Sprint].Currentmember.Level.Name = 'Sprint' Then Case whe…

Martins / eazyBI support team

[Mauro_Bennici]

Greetings Martins,
Yep I stumbled upon something similar and I’m working on it. I noticed that the real issue is elsewhere (other threads).

Thanks for the support!