Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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

binu_acs
ポラリス
スポイラ
image.png
Hub119
12 - Quasar
12 - Quasar

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.

スポイラ
Challenge 437 Image.png
RolandSchubert
16 - Nebula
16 - Nebula
スポイラ
W437.jpg
mmontgomery
11 - Bolide
11 - Bolide

c437

スポイラ
Took me longer than I wanted for data prep, had to look at answers and reverse engineer it
c437.png
ed_hayter
パルサー
スポイラ
image.png
Luke_C
17 - Castor
17 - Castor
スポイラ
image.png
TurboToad
ボリード

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

 

スポイラ
437.PNG
ggruccio
ACE Emeritus
ACE Emeritus

Take time to understand the structure of the data.

 

スポイラ
Screenshot 2024-08-12 153614.png
Chris-Nienart
アステロイド

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

 

スポイラ
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
アステロイド
スポイラ
Capture.PNG