Board-related reports with multiple projects and multiple boards

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

1 Like