Hello,
Is it possible to change the time of project prediction ?
In the Project Prediction report, the project predicted date take into account all issues since the start of the project, I want to have the velocity just for the last 3 months.
I added a new calculated member in the Time dimension for the period to track the performance for the prediction. (“Last 3 months”):
I tried to change the project predicted date to take into account just the last 3 months but it’s not working:
Cache(
Case when
([Measures].[Issues resolved],
[Time].[Last 13 weeks]) > 0
AND
([Measures].[Issues due],
[Time].CurrentHierarchy.DefaultMember) > 0
Then
DateAddDays( Now(),
– add days to reach this ammount
Cache(
– all currently open stroy points
([Measures].[Issues due],
[Time].CurrentHierarchy.DefaultMember)
/
– divided by days performance
Cache(
– resolved story points in last 13 weeks
([Measures].[Issues resolved],
[Time].[Last 13 weeks])
/
– days in the last 13 weeks
DateDiffDays(
‘13 weeks ago’,
‘today’)
)
)
)
End)
Thank you
