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?