Weekly Challenge

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

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

Submit Feedback
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.

Challenge #132: When Will Community Hit 1,000,000 Posts?

Highlighted
8 - Asteroid

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

Highlighted
Alteryx Certified Partner
Spoiler
Challenge_132.png
Highlighted
Alteryx Partner

Preview:

Spoiler
workflow.JPG

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

Highlighted
8 - Asteroid

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

Highlighted
Alteryx Certified Partner

My solution :)

Spoiler
challenge_132.PNG
Highlighted
8 - Asteroid

my solution

Highlighted
12 - Quasar
12 - Quasar
Spoiler
Challenge 132.PNG
Highlighted
8 - Asteroid

Hi! Here my solution :)

 

Spoiler
solution_132.PNG
challenge 132.PNG
Highlighted
8 - Asteroid
 
Highlighted
Alteryx Certified Partner

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