AnsweredAssumed Answered

Cumulated actual and forecast in one chart

Question asked by andreassauer on Feb 20, 2019
Latest reply on Feb 21, 2019 by andreassauer



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.