Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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 #437: International T20 Cricket Stats

binuacs
Polaris
Saqueador
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.

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

c437

Saqueador
Took me longer than I wanted for data prep, had to look at answers and reverse engineer it
c437.png
ed_hayter
Pulsar
Saqueador
image.png
Luke_C
17 - Castor
17 - Castor
Saqueador
image.png
TurboToad
Bólide

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

 

Saqueador
437.PNG
ggruccio
ACE Emeritus
ACE Emeritus

Take time to understand the structure of the data.

 

Saqueador
Screenshot 2024-08-12 153614.png
Chris-Nienart
Asteroide

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

 

Saqueador
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
Asteroide
Saqueador
Capture.PNG