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 #349: Analyze the World Cup Event

AYXAcademy
Alteryx
Alteryx

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

 

To solve this week’s challenge, use Designer Desktop.

 

This challenge comes to us from @Pawel_Paleczny  Thank you for your contribution.

 

The FIFA World Cup is currently taking place in Qatar. Pavel would like to perform analyses on the event.

 

The first dataset contains information about the stadiums: stadium name, city, capacity, latitude, and longitude.

The second dataset contains information about the events: match number, round, dates, location, which teams are playing, and the group or phase.

 

For this challenge:
1. Assuming that each match will have a full audience, find the top 10 teams that could have the largest audience in the group stage.
2. Find the three cities with the most World Cup matches.

Flo_P
Asteroide

Quick and dirty

ggruccio
ACE Emeritus
ACE Emeritus

Fun quick challenge!

Saqueador
ggruccio_0-1670851901731.png

 

benjimoser
Cometa

My solution using RegEx Parse and the Arrange Tool.

 

Saqueador
benjimoser_0-1670852132033.png

 

 

binuacs
Arcturus
Saqueador
binuacs_0-1670853640946.png

 

alexnajm
16 - Nebula
16 - Nebula

Just got back from the World Cup - what a tournament!

Saqueador
Challenge 349.PNG
sgarbev
Meteoro
Saqueador
sgarbev_0-1670855947989.png

 

balajilolla1
Asteroide
Saqueador
Solution Attached

balajilolla1_0-1670856128985.png

 

ahsanaali
Bólide
Saqueador
ahsanaali_0-1670857671589.png

 

JBarr
Asteroide

Done.