Board-related reports with multiple projects and multiple boards

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:

[Sprint].CurrentMember.getBoolean(‘Closed’) AND
NOT IsEmpty([Sprint].CurrentMember.get(‘Complete date’))),
[Sprint].CurrentMember.get(‘Start date’),

1 Like

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.

Martins / eazyBI support team

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!