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: