Burn down chart per projection needed per day and real expenses

Hello to all i’m trying to create a burndown chart per projection where

projection = total planned hours in the sprint / productivity needed per day

this same formula above in dividing all working days as in the print of excel exemplo

and the real expenses that is

real expenses = total planned hours in the sprint / (real )real time spent

this same formula above in dividing all working days as in the print of excel exemplo

A print of both formulas in excel and a chart for ilustrate and a file to dowload to understand


i would like to create this in eazy bi but how can i do this ? i have no idea how to make this, how to create a repetitive loop to dividing total hours over real per day in sprint

1 Like

Hi,

You can use the visiblerowset to find the first item.

Try creating new calculated measure using this formula:

(VisibleRowsSet().Item(0).Item(0),
[Measures].[Total planned hours in the sprint that I will spend]
)
-
Sum(
  {
    Filter(
    [Time].CurrentHierarchyMember.level.Members,
    Rank(
    [Time].CurrentHierarchyMember,
    VisibleRowsSet()
  ) = 1
  ).item(0):
  [Time].CurrentHierarchyMember},
  [Measures].[Real]
)

Martins / eazyBI

1 Like

can you show me measure of burndown values and start value ?

@Lucas_Silva_Dantas_A

“start value” is just the simple integer “48”

“Burnndown values” is the formula from above:

(VisibleRowsSet().Item(0).Item(0),
[Measures].[Total planned hours in the sprint that I will spend]
)
-
Sum(
  {
    Filter(
    [Time].CurrentHierarchyMember.level.Members,
    Rank(
    [Time].CurrentHierarchyMember,
    VisibleRowsSet()
  ) = 1
  ).item(0):
  [Time].CurrentHierarchyMember},
  [Measures].[Real]
)

Martins / eazyBI

isn’t worked for me, the values are returning negative or with no sense print of values that are returning

Start value
image

Total planned hours in the sprint that I will spend

real 2

image

with the values selected would return the values like this

and this is what happening when i change the measures puting start value as first field and planned in second, almost got correct


** ------ ------ ------ ------The correct- ------ ------ ------**

image

@martins.vanags this is possibly happening because is considering weekend, there is a way to desconsidere the weekend ?