Forecasting month volume by days of the week

I am trying to forecast my monthly case volume by using month to date actuals, by day, as the predictor.

My daily volume fluctuates dramatically - so if I have 5 Fridays in a month vs 4 Fridays my volume can be very different.  I have created a custom dimension to convert Work Date (DD-MM-YY) information into Mon, Tue, Wed, Thu, Fri, Sat, Sun.

Now I am trying to forecast the remaining days of the month volume based on the actuals that have come in by day so far in the month.  How do I create a forecasted day for each day of the week, and then tie it into how many of those days are remaining in the month?

0 4 1,026
4 REPLIES 4