We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

Quick and dirty

ggruccio
ACE Emeritus
ACE Emeritus

Fun quick challenge!

Spoiler
ggruccio_0-1670851901731.png

 

benjimoser
9 - Comet

My solution using RegEx Parse and the Arrange Tool.

 

Spoiler
benjimoser_0-1670852132033.png

 

 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1670853640946.png

 

alexnajm
16 - Nebula

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
11 - Bolide
Spoiler
ahsanaali_0-1670857671589.png

 

JBarr
8 - Asteroid

Done.