Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #171: 2019 Grand Prix US - Heat 2

Highlighted
Alteryx Certified Partner

Here's my solution.

Thanks,

Chris

Highlighted
Alteryx Partner
Spoiler
171.PNG
Highlighted
Alteryx Partner

I like the "SUCCESS" field in the output.  Let's get some tubas to those kids!

 

Spoiler
Process:
- Calculate Pct of HH with school-age kids
- Calculate Pct of HH with families
- Sort by Pct of HH with school-age kids (desc)
- Assign RecordID to Pct of HH with school-age kids
- Sort by Pct of HH with families (desc)
- Assign RecordID to Pct of HH with families
- Sort by Avg HH Spend on musical instruments (desc)
- Assign RecordID to Avg HH Spend on musical instruments
- Calculate Avg of the three ranks calculated above, i.e. Overall Rank
- Sort by Overall Rank (Asc)
- Calculate Running Total of HH
- Filter for Running Total <= 10000
- Clean-up fields for comparison


MySolution.PNG
Highlighted
Alteryx Partner

Challenge 171 is done!

 

Spoiler
challenge 171 JMS solution.PNG
Highlighted
Asteroid

Fun!

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

First pass was a a bit long... found a way to reduce the number of steps with the transpose... just wish I came up with it more quickly.

Spoiler
Weekly Challenge 171 (solution).png

Highlighted
Quasar

 My solution:

 

Spoiler
Capture.JPG
Highlighted
Asteroid
 
Highlighted
Asteroid
Spoiler
Challenge 171 2020-02-19.jpg
Highlighted
Alteryx Partner
Spoiler
dsmdavid_0-1582122080952.png