I have a Original Estimated Hours but, I want to create a burndown chart

Questions & Answers
1

I have Original Estimated Hours. Now, I want to create another measure that should work like this.

First of all, The entire report should be filtered with the current Sprint which shows the date range from Sprint Start Date to Till Sprint End Date. Now, I want to take the sprint first day Original estimated hours and do divided by 10 as we remove weekends from the data. For example, if my first value is 350 then the avg will be 35. Now, I want to do cummulate subtraction on a daily basis which will 350-35=315 and 315-35=280…..it comes to 0. I want to this measure. Can anyone help me how to achieve this. With this measure, I can create burndown

2

Hi,

There are different ways to draw the optimal burndown (or Guideline) of the original estimates per sprint. You can find some burndown chart examples on the eazyBI demo account: Sprints Overview - Jira Demo - eazyBI .

For your specific case, the following steps should work:

-) Add the Sprint dimension filter to the report pages and the Time day level to the report rows.

-) Create the custom measure for the Time filtering, that will filter the sprint range:

CASE WHEN
  DateBetween([Time].CurrentHierarchyMember.StartDate,
    DateAddDays([Sprint].CurrentHierarchyMember.get('Activated date'), -1),
    CASE WHEN [Sprint].CurrentHierarchyMember.getBoolean('Closed')
    THEN [Sprint].CurrentHierarchyMember.get('Complete date')
    ELSE
      CASE WHEN DateCompare([Sprint].CurrentHierarchyMember.getDate('End date'), Now()) > 0
      THEN [Sprint].CurrentHierarchyMember.get('End date')
      ELSE Now()
      END
    END
  )
THEN 1
END

-) Create the measure giving the Total scope of the sprint original estimate:

([Measures].[Original estimated hours],
[Time].CurrentHierarchy.DefaultMember)

-) Create the Guideline measure:

[Measures].[Total scope]*
(1-
  Rank(CurrentTuple(VisibleRowsSet()),VisibleRowsSet())
  /
  Count(VisibleRowsSet())
)

-) Switch the chart to the line chart:

image
image1784×1204 184 KB

Kindly,

Janis, eazyBI support