We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
8 - Asteroid

Quick and dirty

ggruccio
ACE Emeritus
ACE Emeritus

Fun quick challenge!

Spoiler
ggruccio_0-1670851901731.png

 

benjimoser
8 - Asteroid

My solution using RegEx Parse and the Arrange Tool.

 

Spoiler
benjimoser_0-1670852132033.png

 

 

binuacs
17 - Castor
Spoiler
binuacs_0-1670853640946.png

 

alexnajm
11 - Bolide

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

Spoiler
Challenge 349.PNG
sgarbev
7 - Meteor
Spoiler
sgarbev_0-1670855947989.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1670856128985.png

 

ahsanaali
8 - Asteroid
Spoiler
ahsanaali_0-1670857671589.png

 

JBarr
8 - Asteroid

Done.