Predicted Storypoint Guideline Burndown Chart from Due Date

Questions & Answers
, ,
1

Hi all,

I am trying to create a “predicted storypoint burndown chart”. I have created tasks which contain storypoint values and due dates. I would like to display a line plot that:

-sums the total story points in this sprint
-subtracts storypoints iteratively based on due date from the total

Is this even possible? Been trying to figure this out for several days ):

Thanks,
Jacob

2

Hi @blacksbe!

If you are looking to add the Predicted story point burndown based on Story due date on one of the Sprint burn-down charts you could use formula as follows:

([Measures].[Story Points remaining], 
  [Time].CurrentHierarchy.Levels('Day').DateMember(
    [Sprint].CurrentMember.get('Start date')
  ))
- 
Sum(
  {[Time].CurrentHierarchy.Levels('Day').DateMember(
     [Sprint].CurrentMember.get('Start date')):
   [Time].CurrentHierarchyMember},
  [Measures].[Story Points due]
)

This finds how many Story points are remaining on the first day of Sprint and subtracts sum of Due Story points from first day of Sprint until the Time member on the row.

Lauma / support@eazybi.com