Velocity Time ago

Questions & Answers
, ,
1

I’m trying to report on velocity per sprints, so am using the following measure [Measures].[Running Story Points velocity for 5 closed sprints]

it displays the results in a table like below

image

When I try to add a Time ago calculated measure to show the difference, sprint by sprint it doesn’t display. This only appears to show any values when I select Time as a dimension rather than sprint, however that doesn’t work for us as we want it to be an agile report and to report per sprint showing whether the velocity has increased or reduced per sprint.

Anyone else managed to create this view?

2

Hi,

Right, the Time ago feature works in the context of the Time dimension.

For the calculation of the difference of velocity between sprints, you can access the velocity value for the previous sprint:

([Measures].[Running Story Points velocity for 5 closed sprints],
[Sprint].CurrentMember.PrevMember)

The calculation of the difference is:

[Measures].[Running Story Points velocity for 5 closed sprints]
-(
  [Measures].[Running Story Points velocity for 5 closed sprints],
  [Sprint].CurrentMember.PrevMember
)

image
image1118×1258 109 KB

Kindly,

Janis, eazyBI support