How many times the issue has been moved in a sprint

Questions & Answers
, ,
1

Hello everyone!

Please help me to build a graph like this.

image
image749×415 14 KB

I want to display the total number of moved issues for each sprint
I found a way to display this value for each issue separately (Measure to show the number of sprints a Issue was worked), but I can’t figure out how to do it by sprints.

I assume the approach is as follows:

  1. Display the total number of issues for each sprint
  2. Count how many times the problem has been moved (as requested above)
  3. Calculate the sum of all problems moved N times

Thanks!

2

@John_Konnor

Try using “Sprint” dimension in rows and create 3 calcualted measures (one for each calculation)
Here is one example to count issues that are committed to the sprint and has been in three sprints (including the current sprint)

Sum(
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issue Sprints] <> "(no sprint)"
AND
--was in two other sprints
NonZero(
  count(
    Filter(
      [Sprint].[Sprint].getMembersByKeys(
      [Issue].CurrentHierarchyMember.get('Sprint IDs')
      ),
      [Sprint].CurrentHierarchyMember.name <> "(no sprint)"
    )
  )
)=3
),
[Measures].[Sprint issues committed]
)

Feel free to copy and adjust the formula for other two calculated measures.

Best wishes,
Martins / eazyBI support

1 Like