@smanda
i have not done this but you can try this.
As it is possible to leverage Alteryx to spread quarterly forecast counts to daily counts using prior year same quarter actuals as an anchor or baseline.
1-First, gather the numbers you need. This includes the forecasts for each quarter and the actual counts from the same quarter in the previous year.
2-Divide the actual counts from last year by the number of days in that quarter. This gives you an average for each day.
3-Now, take the forecasts for this quarter and multiply them by the average daily number you calculated earlier. This spreads out the forecasts over each day
4-Create a list of dates for this quarter, making sure you cover every day. Then, match up the daily forecasts you calculated with these dates.
Double-check everything to make sure it looks right.
this should work
