Count the number of sprints an issue has gone through

[briantaylor]

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

[martins.vanags]

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