Count Function

chengchenggan
chengchenggan
in Modeling

Hi,

 

How could I count days by 1) weekday type and 2) Actual data or not. Ideal result would show X day for "Weekend" for Actual data, Y day for "Holiday" for Forecast data.. etc. 

  • Index is a "Day" list from 1 to 31.
  • Column "Weekday" and "Actual data" are manual input. 
  • "Value" is a supporting column. Feel free to change the format or add/delete. 

 

chengchenggan_0-1611265994546.png

 

Ideal result:

chengchenggan_1-1611266100263.png

 

Thanks,

Jane

Tagged:

Best Answer

  • jasonblinn
    jasonblinn
    Answer ✓

    @chengchenggan 

    I think there are a couple of ways to go about this. The most simple would likely be to stage it out the way that you have it, but also add a line item for the forecast. Both of these are based on the "Actual" line item.

    jasonblinn_0-1611279382011.png

     

    From there, you can just create a new module that has the list that contains "Weekday, Weekend, and Holiday"  as a dimension, and have a line item for Actual Day Count, and another for Forecast Day Count.

     

    jasonblinn_2-1611279601420.png

    For the formula, you want to pull the Forecast or the Actual line item from the first line item and sum it across the weekday line item.

    My formula here is: Monthly Module By Day.Forecast[SUM: Monthly Module By Day.Weekday]

     

    Hope this helps!
    Jason

     

     

Answers

Categories