Tracks the number of points moved to Dev Complete over the previous number of sprints
Enables me to filter down to specific developers to see how many points they’re moving to Dev Complete in each sprint
I found another community post that got me part of the way there, but has some unexpected behavior; the filtering (via dimensions as Pages) seems wildly inconsistent. I used the following formula to calculate points moved to Dev Complete per Sprint:
-- filter issues having a particular transition during an active sprint
([Measures].[Transition to status first date], [Transition Status].[Dev Complete]),
[Sprint].CurrentMember.Get('End date') )
-- and issues were in a selected sprint
AND [Measures].[Issues history] > 0
[Issue].CurrentMember.get('Story Points') )
Filtering the results by Assignee gives weird results because the current Assignee is typically not the one who moved it to Dev Complete. I added a new field called “Primary Developer” and populated it with the correct users for all relevant tickets, but it’s working as expected for some users and not others (a Primary Developer I can confirm has tickets moved to Dev Complete within recent sprints shows up with 0 points moved when I add the filter).
Does anyone know why I’m experiencing this issue, or have a better way for me to accomplish my goal here?
Use the dimension “Transition Author” to see a user who moved issues to Dev Completed status. This dimension is designed to work with change history and show transition status changes. On the other hand, dimension “Assignee” represents the issue field Assignee current or past value according to the selected measure.
I’m trying to use the following tuple based on your recommendation:
( [Measures].[Sprint Story Points added],
[Transition Status].[Dev Complete],
However, “Sprint Story Points added” ("Story Points added doesn’t exist in my EazyBI) doesn’t seem to capture the right information either; when I add just “Sprint Story Points added” to a report I get 105, 132, 111, 80, 104 for the last 5 sprints, and Excel analysis of the same period shows 171, 223, 207, 240, and 177 just for moved to Dev Complete alone. Trying to create the tuple you described results in 0, 9, 3, 0, 0 for that period. What am I doing wrong here?