I’m looking to do something similar but without having to create so many calculated members.
My goal is a report that shows sprint story point activity for the last 8 closed sprints. For example:
However, in our case there are something like 65 teams (boards). Ideally I would be able to select a Board in a Page filter and only need 1 report. I haven’t managed to be able to configure this, though. The approach I’ve taken would require 65 calculated members and 65 separate reports. I guess I can live with 65 reports but creating the 65 calculated measures is not desirable. I would be happy with a list of all of the last 8 closed sprints from all boards but grouped by board. Then, at least I can select just the board I want for the report and expand it to get the sprints.
I’ve only managed to either get a list of the sprints (without the boards), or the boards with all of the sprints.
For instance, I end up with this (the boards I want but with all the sprints):
…or this (the sprints I want but for ALL boards, including boards I don’t want, and not grouped by board):
This has been my approach. I have a calculated member that aggregates the team boards I’m interested in, as such:
[Sprint].[Team Board 1],
[Sprint].[Team Board 2],
[Sprint].[Team Board 3]
This gives me the results in the first picture (All team boards). I need to do this because there are boards that are imported that I do not want to report on.
My other attempt was to create a calculated member that filtered out the last 8 closed sprints but this gave me the results in the second picture (Last 8 closed sprints). Like this:
-- last 8 closed sprint in the board
I am trying to change the set expression in the Generate function to give me those last 8 sprints but grouped by board like in the other calculated member (e.g.,
[Sprint].[All team boards].Children) , but that doesn’t work - in fact, nothing is returned.
Is what I’m trying to do even possible? This is a recurring issue for me as I want to do many reports besides sprint story point activity and I keep running into the same issue.
Any suggestions for a different approach would be greatly appreciated.