Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #24: ARIMA Time Series

Watermark
12 - Quasar
12 - Quasar
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
13 - Pulsar
Spoiler
FrederikE_0-1647433749617.png

 

fluteman
8 - Asteroid

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
9 - Comet

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