Tracking sprint velocity to specific status

Hi all,

I’m trying to create a report that:

  1. Tracks the number of points moved to Dev Complete over the previous number of sprints
  2. 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:

Sum(
  Filter(
    -- filter issues having a particular transition during an active sprint
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateBetween(
      ([Measures].[Transition to status first date], [Transition Status].[Dev Complete]),
      [Sprint].CurrentMember.get('Start date'),
      [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?

Thanks,
Ryan

Hi @rbelmont,

You may try another approach for the calculation and check the Story Point value when the issue changed status to “Dev Completed”.

For the calculated measure, use a tuple of measure “Story Points added” and “Transition Status” you are interested in. The expression might look like this:

( [Measures].[Story Points added],
 [Transition Status].[In Progress],
 [Transition Field].[Dev Completed])

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.

A similar solution:

Best,
Zane / support@eazyBI.com

Hi @zane.baranovska,

I’m trying to use the following tuple based on your recommendation:

( [Measures].[Sprint Story Points added],
 [Transition Status].[Dev Complete],
 [Transition field].[Status])

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?

@rbelmont, could you share the report definition and a screenshot of the report so I can see what else is on report rows, columns, and pages and how it looks to you?

If you do not want to share this information here, you may send it to eazyBI Support.