Rolling Forecast Chart

tompatrick.ting
tompatrick.ting
in Modeling

Hello,

 

Is there a way I can create a line chart that connects the Actual data and the Forecast? 

 

Attached is the screenshot from Excel that I plan to create in Anaplan.

tompatrickting_0-1605691740767.png

 

Thanks,

Tom

Tagged:

Answers

  • Jitendra.Vishnolia
    Jitendra.Vishnolia

    Hey @tompatrick.ting ,

     

    You can bring Actuals and Forecast data in one common line item (applying If else condition on Time dimension) and then create a line chart.

    However, the line chart won't of 2 different colors as shown in excel. 

     

     

    ~ Jitendra

  • Sricharan
    Sricharan
    edited April 16

    Hello @tompatrick.ting

    I have used some rearrangements of line items and tricks to remove trailing zeros and this was the resultant outcome.

    image.png

    The budget trails along, the actual ends and forecast starts at the date of selection.

    -Sricharan

  • SriNitya
    SriNitya

    In one line item bring data of actuals and forecast and then populate the graph it would work for you.

  • Sricharan
    Sricharan
    edited April 16

    Hello @SriNitya

    If one line item is used for continuity purposes, the shift to a different version (color change/show or hide a version, etc.) cannot be observed. Hence multiple line items are used, and conditions are put such that 'NaN' shows up instead of zeroes to avoid erros in graphical representation caused by trailing and leading zeros.

Categories