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

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

Hi Maveryx,

 

A solution to last week’s challenge can be found here.

 

This challenge was created by William Davis! Thanks, William, for submitting your idea for this Weekly Challenge.

 

You have been tasked with analyzing historical international cricket T20 results to provide the US with some insights.

 

The data available covers every men’s international T20 match from 2005–2022 and was extracted in JSON format. Use your parsing skills to obtain the specific information required to solve the tasks.

 

The data consists of three elements: innings, info, and meta. The field identified with the info element contains all the relevant information.

Hint: Assess the three elements after you parse the data.

 

Your tasks:

  1. How does the United States rank worldwide for total number of wins?
  2. Which team is the most successful?
  3. Who are the six players from the most successful team with the most games played?

 

Need a refresher? Review the following lessons in Academy to gear up:

 

Good luck!

 

AYXAcademy_0-1721836484055.png

 

 

Sources:

https://www.majorleaguecricket.com/

www.cricsheet.org

Kenda
16 - Nebula
16 - Nebula
スポイラ
image.png
griffinwelsh
クエーサー

My solution

aatalai
オーロラ

C437

Tofel
コメット
スポイラ
Challenge 437.JPG

patrick_digan
17 - Castor
17 - Castor
スポイラ
image.png
danbostrom
アステロイド

 

 

BKreutel
アトム

Here is my solution:

 

スポイラ
Spoiler 437.png
ahsanaali
ボリード
スポイラ
427.png

balajilolla2
ファイアボール
スポイラ
Solution Attached

Screenshot 2024-08-12 084651.jpg