count of stories for all sprints (closed , inprogress, future)

Amar January 12, 2018

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

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events