Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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 #435: Universal Summer Cup Stats – Part 1

AmandaTSY
5 - Atom

Similar to another user, my solution for task 2 is also producing more records than the target output likely due to the way the best athlete is filtered for. 

Supriya2203
8 - Asteroid

My solution

Annabelle
7 - Meteor

With a couple of extras... Showing the ties for places, and a medals-table style ordering where only one medal per event (not per competitor) counts.

Prathameshmanakapure
8 - Asteroid

My Solution

patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
Chris-Nienart
8 - Asteroid

@griffinwelsh good insight on the ties! I also think that success could be measured by any medal, so I included medal counts (swap out for points) in my workflow too.

 

Spoiler
I used back-to-back summaries to get the max aggregated points.I used back-to-back summaries to get the max aggregated points.

 

the_data_guy
6 - Meteoroid

My solution. 

Spoiler
 
guntuv
6 - Meteoroid

C435 completed

davidhardister
8 - Asteroid
Spoiler
Capture.PNG

Luke_C
17 - Castor
17 - Castor
Spoiler
image.png