Filter sprints by board name

Hi - I need help with filtering sprints based on the name of the board the belong to.

We have a user defined “Team Name” field in Jira and several “teams” within the same jira project and they in turn have created several boards and a lot of sprints over the last 3 years.

I need to be able to get to the sprints for one particular board (team).

Tried in many different ways now with getting a calculated member in the sprint dimension right, example that doesn’t work:
Aggregate({
Filter(
[Sprint].[Board].Members,
[Sprint].CurrentHierarchyMember.Name MATCHES ‘Customer Dialog’
)
})

Any help would be appreciated, here’s a screenshot of the kind of data I’m working with:

If I understand correctly You want to have data for only one board - ‘Customer Dialog’?

I would try such syntax
Aggregate([Sprint].[Customer Dialog])

1 Like

Simple as that, now I can aggregate several boards together.

Thank you!

Hi @Anders and @rasiak,

Another approach would be to use Sprint dimension on both rows and pages at the same time. This way you can filter by board name and represent on rows. Please see the documentation how to do that:
https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Pagedimensions

Best,
Zane / support @eazyBI.com

Hello I have a similar requirement but only need to filter the last 6 sprints for each board . How can I achieve that ?