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 #437: International T20 Cricket Stats

binuacs
21 - Polaris
Spoiler
image.png
Hub119
11 - Bolide
11 - Bolide

Solution attached... my US ranking was slightly different from the expected output as I decided to incorporate win rate to break ties between countries with the same number of wins.

Spoiler
Challenge 437 Image.png
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
W437.jpg
mmontgomery
11 - Bolide
11 - Bolide

c437

Spoiler
Took me longer than I wanted for data prep, had to look at answers and reverse engineer it
c437.png
ed_hayter
12 - Quasar
Spoiler
image.png
Luke_C
17 - Castor
17 - Castor
Spoiler
image.png
TurboToad
10 - Fireball

Took a minute of staring at the data to come up with what was needed.

 

Spoiler
437.PNG
ggruccio
ACE Emeritus
ACE Emeritus

Take time to understand the structure of the data.

 

Spoiler
Screenshot 2024-08-12 153614.png
Chris-Nienart
8 - Asteroid

There really ought to be a rank tool that accounts for ties.

 

Spoiler
Accounting for ties by selecting list of entries associated with the rank.Accounting for ties by selecting list of entries associated with the rank.

 

a640687
8 - Asteroid
Spoiler
Capture.PNG