Custom Time Range - Switchover

MarkTurkenburg_*8288
MarkTurkenburg_*8288
in Modeling

Hi Team,

 

The Time Range training states that 'If you want to use the switchover date, you'll want to use the model calender' (see below)

 

I ran some tests and Switchover was working fine when using a Time Range although you cannot select a Switchover Period per Time Range, it is as per the Model Calender

 

Does anyone know what this comment below is referring to?

 

Thanks

 

Mark

 

Switchover.PNG

Tagged:

Best Answers

  • rob_marshall
    rob_marshall
    Answer ✓

    @MarkTurkenburg ,

     

    Native Switchover can only be set in the Version section of settings:

    2020-05-07_15-07-13.png

     

    But, you can always use DCA and base it off a setting (line item) to make the cells read only.  Just be careful with this as your formula will need to get the proper data (Actuals vs. Forecast).  For example, if boolean (the read only boolean) then actual data else forecast.

     

    Hope this helps,

     

    Rob

  • rob_marshall
    rob_marshall
    Answer ✓

    @MarkTurkenburg ,

     

    I see where you are coming from now and where the disconnect is.  In the image, it is stating you have to use the "granularity" of the model timescale, not the actual timescale.

     

    So, for a monthly model:

     

    2020-05-07_19-14-25.png2020-05-07_15-07-13.png

     

    And for a weekly model:

    2020-05-07_19-14-57.png2020-05-07_19-15-10.png

     

    Does that help clear it up?

Answers

Categories