Hi,
This community is still young and growing; sometimes answers are not provided as quickly as you would hope.
I understand that you would like to get only those transitions which happened during dates while a sprint was active. Measures Transitions to status and Transitions to status issues count are associated with Sprint dimension through issues within a sprint. Therefore measures may return transitions an issue had even before a sprint had started.
This is what you may do to get an accurate amount of transitions during a sprint.
-
Define a new calculated measure to get only measure Transition to status values only for a period while a selected sprint was active. A formula may look like this:
([Measures].[Transitions to status], [Sprint Status].[Active]) -
Define another calculated measure to return count of issues which transitioned while a selected sprint was active. A formula may look like this:
([Measures].[Transitions to status issues count], [Sprint Status].[Active]) -
I recommend using Transition dimension to select particular reopening transitions you are interested in.
Best,
Zane Baranovska / support@eazybi.com