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
Página1
total planned hours in the sprint that I will spend,50
consecutive sprint days,12
working days,10
productivity needed per day,5,total / 10 (working days)
day,projection,real,real...
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
martins.vanags:
(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]
)
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
martins.vanags:
(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]
)
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 ?