# 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 Total planned hours in the sprint that I will spend

real 2 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- ------ ------ ------** @martins.vanags this is possibly happening because is considering weekend, there is a way to desconsidere the weekend ?