Cumulated actual and forecast in one chart

Andreas Sauer
Andreas Sauer Active Partner
Fourth Anniversary Advocate Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board
in Platform

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.

Answers

  • Dietmar Jeschkeit
    Dietmar Jeschkeit Active Partner
    Fourth Anniversary 100 Comments 25 Up Votes 25 Likes
    edited March 2020

    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.

    image

  • Andreas Sauer
    Andreas Sauer Active Partner
    Fourth Anniversary Advocate Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board

    Thank you for this suggestion. This is exactly what I'm looking for.

     

    Best regards,

    Andreas

Categories