Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #132: When Will Community Hit 1,000,000 Posts?

MAAbdullahAlMubarah
8 - Asteroid

For the period before 2017 shall it will be considered in the data of training? 

Natasha
9 - Comet
Spoiler
Challenge_132.png
sidneyjacobs
7 - Meteor

Preview:

Spoiler
workflow.JPG

Really fun challenge that I forgot to upload. We've used this as a nice example for customers already.

TharunReddy
8 - Asteroid

I came to know about the ARIMA tool and it's working by this challenge!!

JoshuaGostick
11 - Bolide

My solution :)

Spoiler
challenge_132.PNG
ipeng
8 - Asteroid

my solution

cplewis90
13 - Pulsar
13 - Pulsar
Spoiler
Challenge 132.PNG
RichoBsJ
11 - Bolide

Hi! Here my solution :)

 

Spoiler
solution_132.PNG
challenge 132.PNG
CRowlatt
8 - Asteroid
 
Verakso
11 - Bolide

Before I do this week Expert Challenge, I thought that I better start out with some of the other Predictive challenges like this one 😃

 

Again the built-in examples and the Tool Mastery pages are at a great help

 

Spoiler
I did struggle a little bit, trying to figure our, how many periods  should be predicted, in other to get enough data to pass the 1.000.000 mark,

So it was a bit of a "trial and error", and I did finally just chose 100 periods. Needles to say, that the model accuracy becomes somewhat off, when you only have 20 periods of data, and trying to predict 100.

But besides that, working with ARIMA and TS models isn't that frightening, and I did manage to match the provided result which is June 2023!
2019-03-27 09_22_25-Alteryx Designer x64 - challenge_132_solution_verakso.yxmd.png

 

Still Climbing

/Thomas