Hi,
I have to make an integrated chart for single epics with the content:
axis x should be time
on axis y (which is %) should be 3 lines
- a cost burnup line starting from 0%, going up as mandays are spent going up towards 100% which is original estimated cost of the project (imported from csv)
- a hipothetical cost burnup line goint up from 0% to exactly 100%, reaching it on the deadline of the epic
- a features ready or features produced line going up from 0% to 100%
My solution so far for:
line nr1.
cumulative spending (MD%)=[Measures].[Cumulated spending (MD)] /[Measures].[Cost estimation (MD)]
where
Cumulated spending (MD)= CumulativeSum([Measures].[Hours spent with sub-tasks])/8
and
Cost estimation (MD)=DefaultContext((
[Measures].[development estimation],
[Epic Link].CurrentMember
))
and development estimation is imported from csv for each epic link
line nr2.
cumulative cost estimation (MD%)= [Measures].[cumulative cost estimation] / [Measures].[Cost estimation (MD)]
where
Cost estimation (MD)=DefaultContext((
[Measures].[development estimation],
[Epic Link].CurrentMember
))
and development estimation is imported from csv for each epic link
line nr3 is a challange for me
i need a calculated measure for filtered issues where tha issue name consists a string ‘FEATURE’
the calculated measure is resolved / created issue for only issues with ‘FEATURE’ in the name and a kind of defaultcontext (i mean valid) for the whole epic.
filtering for ‘FEATURE’ issues in the table design is not a solution because cost should be calculated for every issue in the epic while feature readyness only for ‘FEATURE’ issues.
Time should start with the day when the status of the epic ticket chaged to ‘in progress’ and end with the day when it changed to ‘DONE’.
Thank you in advance
László