Count the number of sprints an issue has gone through

Questions & Answers
#1

I have a request to get a list of issues and the count of sprints the issues has been places.
I can get a list of sprints that an issue has gone through but to have that list as a count of sprints

Screen Shot 2021-01-14 at 10.10.14 AM
Screen Shot 2021-01-14 at 10.10.14 AM1706×671 156 KB

1 Like
#2

Hi @briantaylor

Try creating new calculated measure using this formula:

count(
[Sprint].[Sprint].getMembersByKeys(
[Issue].CurrentHierarchyMember.get('Sprint IDs')
)
)

That should count the sprints for “Issue” level members in the report

Martins / eazyBI support