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
6 - Meteoroid

My Solution!

Highlighted
7 - Meteor

My solution predicts June 2023

Highlighted
12 - Quasar
12 - Quasar

Looks like I'm in good company!. @NicoleJohnson I'm looking forward to challenge #378!

Highlighted
Alteryx Certified Partner

Solution attached.

 

Spoiler
challenge_132_spoiler.png
Highlighted
10 - Fireball

Same result...

 

Spoiler
challenge_132_completed.jpg
Highlighted
8 - Asteroid

Great challenge! Very best of luck to the community in the future too 🙂 

7 - Meteor

Initially forgot to include the posts from January 2017 - August 2018, after that it checks out! 

Highlighted
Alteryx Partner
Spoiler
Capture.PNG
Haven't used the forecast tools in while
Highlighted
7 - Meteor

Certainly not the most efficient possible workflow, but I got there.  (Some of my less efficient choices were on purpose, such as keeping actual counts as a separate field from forecasted counts, even though it meant a little more data prep and a marginally more complex formula.)

 

I've been meaning to do more with the time series tools, predictive tools, etc., so this was good practice!

 

Spoiler
WC132.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Cool challenge, never had the chance to get my hand on the time series!

Hope the model is wrong and we're gonna be there faster 🙂