We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We’re aware of an issue with email notifications. If you notice you’re not receiving emails from the Community, please check your SPAM folder and release the emails. This should temporarily resolve the problem while we work behind the scenes to solve the larger issue with our mail sender. Thank you for your patience!

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #24: ARIMA Time Series

Watermark
8 - Asteroid
Spoiler
MT Solution 24.png

davidhardister
8 - Asteroid

Complete

Tubalady
8 - Asteroid

I seem to be getting the hang of this...

jon_amanrich
8 - Asteroid

My 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
jon_amanrich_0-1642704490316.png

 

Jeune
7 - Meteor

Spoiler, please find my enclosed my solution

Challenge 24.PNG

 

duartepimentel
8 - Asteroid

Solution attached !

Robinvm
8 - Asteroid

Solved

FrederikE
8 - Asteroid
Spoiler
FrederikE_0-1647433749617.png

 

fluteman
7 - Meteor

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.

mattnason1
8 - Asteroid

Never used the time series tools before.  Nice to see that they are pretty simple.