Distinct count of Sprint Issues Added

Questions & Answers
1

While using “Sprint Issues Added” Measure, we are getting multiple count against couple of individual sprint issues. This may be due to this issues transitioning to sprint backlog multiple times.

image
image1404×1118 100 KB

I tried using this particular formula by replacing [Measure].[Transitions to] with its counter part distinct measure.

(
[Measures].[Transitions to status issues count],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
– An issue was added or created in an active sprint
[Issue Sprint Status Change].[(none) => Active]
)

However, it gives me empty result. What am I doing wrong here?

Thanks
Bhavin

1 Like
2

Any help here will be highly appreciated.

3

Hi @Bhavin_Kamani!

Transitions to status issues count gives a distinct count of issues in Transition status. In this case, to get a distinct count of Sprint issues added you would be using the general hidden Transitions to issues count measure. Please try the following

( [Measures].[Transitions to issues count],
  [Transition Field].[Sprint status],
  [Sprint Status].[Active],
  -- An issue was added or created in an active sprint
  [Issue Sprint Status Change].[(none) => Active]
)

Lauma / support@eazybi.com

4

Thanks Lauma. This works pretty well. For other measures such as Sprint Issues removed, completed etc, would a similar approach will work?