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?

scarey94
6 - Meteoroid

My Solution!

ebarrus
7 - Meteor

My solution predicts June 2023

ggruccio
ACE Emeritus
ACE Emeritus

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

KOBoyle
11 - Bolide

Solution attached.

 

Spoiler
challenge_132_spoiler.png
OldDogNewTricks
10 - Fireball

Same result...

 

Spoiler
challenge_132_completed.jpg
CHarrison
8 - Asteroid

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

AKnutson11
7 - Meteor

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

George_Walker
8 - Asteroid
Spoiler
Capture.PNG
Haven't used the forecast tools in while
cbrettlockard
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
Ladarthure
14 - Magnetar
14 - Magnetar

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 :)