community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #170: 2019 Grand Prix US - Heat 1

Meteor

703.1

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

My solution - took around 10 minutes

Alteryx Partner
Spoiler
170.PNG
Alteryx
Alteryx

heat 1!

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