Hi,
we are following Safe so planned all stories for each iteration in jira. lets say we have 2 teams and 5 sprints in each pi. here is the jira looks like.
Team 1 - Sprint 1.1 - 5 stories
Team 1 - Sprint 1.2 - 7 stories
Team 1 - Sprint 1.3 - 6 stories
Team 1 - Sprint 1.4 - 8 stories
Team 1 - Sprint 1.5 - 9 stories
Team 2 - Sprint 1.1 - 4 stories
Team 2 - Sprint 1.2 - 7 stories
Team 2 - Sprint 1.3 - 5 stories
Team 2 - Sprint 1.4 - 7 stories
Team 2 - Sprint 1.5 - 6 stories
Currently we are in sprint 1.3 for both teams. We need to show count of stories for all 5 sprints (closed, inprogress, future) in eazyBI .How can we get above counts in eazyBI ?
tried this
count(
Filter([Issue].[Issue].Members,
[Issue].[Issue].CurrentMember.getString('Sprint') matches [Sprint].CurrentMember.Name
),ExcludeEmpty
)
but it's giving count 0 for closed sprints 1.1 & 1.2
Thanks