Cumulated actual and forecast in one chart

Andreas Sauer

Hello,

 

we have a chart in Excel that shows the cumulated values of reached milestones (thick lines). Additionally we have a line that shows the cumulated planned milestones in the next weeks (dashed line). The reached milestones stop at the current week while the plan values are shown for the following 15 weeks.

 

I created the same chart in Board and set Yearly Moving Total to my two cubes (reached and planned milestones). Board shows both cubes for the complete time range. Is it possible to stop accumulation of the reached milestones at the current week (so reached milestones are only shown in the past) and planned milestones are accumulated and shown in the future?

 

Thanks in advance.

Dietmar Jeschkeit

Hi Andreas,

dashed lines are not possible in BOARD. If I understand you right your problem is that BOARD shows the line for actual over the whole time period and you want to stop the line at a specific date (maybe today).

To give you an idea I built an example based on month (not week - if you use a cube with value 1 on every week until your date you can use it for calculation instead of my date comparison).

 

Just have a look. In the legend of Actual you must check hide Zeros.