Version Report with dynamic Scope Creep line

Questions & Answers
1

Hi Support-Team,

could you please help me out creating a version report.
The report is supposed to show the cumulated story points resolved and an ideal burndown.

In addition I would like to show the “cumulated Scope Creep”.
By now I am only able to show the Scope Creep (Story Points change) on a daily basis.

Now I would like to create a dynamic line, which shows the cumulated value for the Scope Creep within the period of time.

Actual Report

Story Points to be done (red line)

CASE WHEN
NOT isEmpty([Measures].[Time within version])
THEN
[Measures].[Total story points]

-Cache(
NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
[Measures].[Story Points resolved])))

END

Burndown in Version (black dash line)

(Filter([Time].CurrentHierarchyMember.Level.Members,
[Measures].[Time within report range] > 0).Item(0),
[Measures].[Story Points to be done])
(*) DateDiffDays([Time].CurrentHierarchyMember.StartDate,
[Measures].[report end date])
/ DateDiffDays([Measures].[report start date],[Measures].[report end date])

Target Report

Cumulated Scope Creep (blue dash line)

Requirements
• Sum all Story Point Changes (in this case: -62 SP + 1 SP = - 61 SP)
• Set this cumulated value (-61 SP) as a dynamic line

SP = Story Points

Burndown in Version (black dash line)

Requirements
• Starting Point: Story Points to be done on 31 Oct 2018
• Ending Point: Value cumulated Scope Creep on 01 Jan 2019

Thank you in advance and do not hesitate to contact me if you have further questions! 

Target%20Report
Target Report.PNG1308×292 66 KB
Target Report

2

This is how the Actual Report looks like at the moment

Actual%20Report
Actual Report.PNG1310×322 33.4 KB

3

Hi @sesi!

We resolved this already on e-mails. Here are the two formulas we ended up having:

Cumulated Scope Creep - Story point change total over report time period

Sum(
Filter([Time].CurrentHierarchyMember.Level.Members,
    [Measures].[Time within report range] > 0),
  [Measures].[Story Points change]
)

Burndown in Version - burndown starting at Story points to be done and ending at Scope creep value in hardcoded dates

CASE WHEN 
DateBetween([Time].CurrentHierarchyMember.StartDate,
    DateParse('31 oct 2018'),
    DateParse('1 jan 2019')
  )
THEN
((Filter([Time].CurrentHierarchyMember.Level.Members,
  DateBetween([Time].CurrentHierarchyMember.StartDate,
    DateParse('31 oct 2018'),
    DateParse('1 jan 2019')
  )).Item(0),
[Measures].[Story Points to be done])-[Measures].[Cumulative Scope Creep])
* DateDiffDays([Time].CurrentHierarchyMember.StartDate,
DateParse('1 jan 2019'))
/ DateDiffDays(DateParse('31 oct 2018'),DateParse('1 jan 2019'))
+ [Measures].[Cumulative Scope Creep]
END

Lauma / support@eazybi.com