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 #170: 2019 Grand Prix US - Heat 1

Highlighted
8 - Asteroid

703.1

Spoiler
2019-11-11_11-32-01.png
Highlighted
Alteryx Certified Partner

My solution - took around 10 minutes

Highlighted
Alteryx Partner
Spoiler
170.PNG
Highlighted
Alteryx
Alteryx

heat 1!

Highlighted
Alteryx Partner

Had to look up what an ETS model was, and guess at the settings, but think I got it.  703.1 seems to be the answer.

 

Spoiler
Process:
- Connect Input tool to zip files
- Group by Year and Session, Count SessionIDs
- Split by Session then repeat following process for each thread
- Generate rows from 1999 to 2018
- Union generated rows with data (manual configuration)
- Add session name (e.g. Summer1) if field is null
- Grab unique records (based on Year and Session Name)
- If Count field is null, then calculate as average of Count for two surrounding years
- Union Summer1 and Summer2 threads
- Sum count of attendees at each session (group by year)
- Run through ETS model with target of Count (left all default settings)
Result: Predict 703.1 for 2019

Prediction.PNGMySolution.PNG


Highlighted
8 - Asteroid

First use of Time Series Tool!

Spoiler
Annotation 2019-12-25 160645.png
Highlighted
Alteryx
Alteryx

Love the Grand Prix Events!!

Spoiler
Snag_4f18ecab.png

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid
Spoiler
Challenge 170 2020-02-19.jpg
Highlighted
Alteryx Partner
Spoiler
dsmdavid_0-1582121158173.png