Sprint Burndown Having a line only for Committed Story Point resolved by time

Questions & Answers
1

Hi,
I am trying to have a new dimension inside my Sprint burndown report that only represent Committed Story Point resolved by the the time.

This is what I tried but it is giving me what I need

Measures].[Story Points committed],
 [Sprint].CurrentHierarchy.DefaultMember) - 
 SUM(
  [Time].CurrentHierarchy.Levels("Day").DateMembers,
  [Measures].[Sprint Story Points committed completed]

As an exemple this is what I am doing in excel.

image
image1541×703 34 KB

2

Hi @Jujuone

You may want to create a measure with a tuple from hidden Sprint dimension, "Sprint incoming State", to get issues by the way how they were added to the sprint (as committed or added during the sprint), combined with the measure “Story Points resolved” which shows on a daily basis resolved story points. In the result, this tuple returns resolved committed story points

([Measures].[Story points resolved],
 [Sprint Incoming State].[Committed])

Best,
IlzeLA, support@eazybi.com

3

Thanks Illlze that works,
Now I need to have by time I tried

Cache(
  Sum({PreviousPeriods([Time].CurrentHierarchyMember),
      [Time].CurrentHierarchyMember},
    [Measures].[Sprint Incoming State].[Committed]
  )
)

But It is not showing the resolution over the time.
If you have some advise.
Thanks again