This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackMy solution for challenge 24 matching with the output in the solution workflow but slightly different from the output in the start file for some reason 🤔
Spoiler, please find my enclosed my solution
Pre-requisite to complete this : Alteryx Predictive Tools with R 4.0.5 needs to be installed to allow you to access ARIMA tools in Alteryx.
Step 1 :
Figure out filling the weeks and then after they've been appended using UNION, do the same for the weeks of the missing months.
The average is an average of the weeks' data; not months' data.
a) And you're filling the missing / nulls with the intra month weekly average and then
b) the month(s) with all weeks missing values with the monthly average.
Step 2 :
Use the ARIMA function and use the output of O for both tools.
We're working with weekly.
note : I peaked at Nicole Johnsons work since I thought the R link would work. It didn't :-( Use the O.