I have wasted like 3 days on this and I am now desperate for help. I am having trouble wrapping my head around this one...I am trying to get to an end product like the following
Ignoring the Plan line (since that is the easiest), this is a cumulative count of tasks by date. The actual is supposed to represent data up until now, the forecast is representing data into the future. They need to be two seperate lines so they show in the legend as follows. In the backend I have done the following:
ExpectedinVersion as DTETasksCompleted,
1 as TaskEDTMeasureID
TaskActualFinishDate as DTETasksCompleted,
2 as TaskEDTMeasureID
The problem is in the chart now I do not know how to write a formula such that my cumulative actual line ends as of this month, and my forecast line begins when this ends. I have DTETasksCompleted as the dimension and the expressions I have so far are
I feel like I am almost there, but I can't figure out where to go from here - I need the blue line to end in Mar 2011, and the red line to start where the blue line ends. Any time I try to add any condition like DTETasksCompleted<=ReloadTime() it doesn't seem to work....
the lines should follow each other till today so depending on how you order them you can get the actuals to overlay the forecast.
currently your actuals flat line after today which you don't want. During the load script you can calculate the maximum date for actuals task. then use this in your actuals calculation to render null if you are past the maximum actual date.