Display Velocity at the Board Level

Questions & Answers
1

Greetings:

Currently the “Velocity for 5 Running Sprints” metric is displayed at the “sprint” level of the Sprint Dimension heirarchy.

I am trying to have just the velocity for the last “X” sprints be displayed at the board heirarchy level instead of the sprint heirarchy level.

I then want to add those board velocities to get total velocity per project per project category.

I’m very new to eazyBI and we are currently evaluating it for purchase.

Thanks!

Alan

image
image.png1070×606 67.9 KB

2

Hi Alan,

To get the last 5 sprints from a board you can use:

Aggregate(
  {
    [Sprint].[D2 board].LastChild.Lag(4):
    [Sprint].[D2 board].LastChild
  }
)

Where the “[Sprint].[D2 board]” is your bookmarked board member. When this is used in Sprint dimension you can also expand the member to see the sprints.

If you do not want to bookmark and create members for every board then you can use this query in measures dimension as well:

Aggregate(
  {
    [Sprint].CurrentHierarchyMember.LastChild.Lag(4):
    [Sprint].CurrentHierarchyMember.LastChild
  },
  [Measures].[Issues resolved]
)

This example returns issues closed in last 5 sprints from a board. With this version you will not be able to expand and see the individual sprints.

I hope that helps.

Gvido Neilands, flex.bi

1 Like
3

Hey Gvidon:

My apologies…I was replying within my email and didn’t realize those messages probably were not reaching you.

I have attached some examples of what I am trying to do within eazyBI…maybe that would be a better starting point as this tool has a high learning curve. My options appear to be endless when it comes to measures and calculations.

41%20PM
Screen Shot 2018-06-14 at 1.53.41 PM.jpg1030×942 139 KB

4

Also looking for an aggregated story burndown as shown here:

54%20PM
Screen Shot 2018-06-14 at 1.53.54 PM.jpg1250×750 107 KB

5

And also I’m trying to graph a predictability curve:

28%20PM
Screen Shot 2018-06-14 at 1.53.28 PM.jpg1502×1252 199 KB

6

Hi Alan,

I will message you private.

7

Hi Gvido, I tried your query above and created a user defined measure to get the board level velocity. However, my board is blank. I see some of the other projects within our organization populate this data. I contacted Eazybi support but have not heard back. Would you be able to help me, I can send you more details via private message if that’s possible. Thanks, Maddi