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 #297: Rubik Cube

AYXAcademy
Alteryx
Alteryx
A solution to last week’s challenge can be found here
 
Weekly Challenge Image 297.pngMany countries host competition where people compete for the fastest Rubik's cube solve times. Using the following three datasets on competitions and competitor solve times, complete the following tasks:
 
1. Find the ten countries that have hosted the most competitions and how many each one has hosted
 
2. Find the difference in average solve times between competitors who are in their home country vs. visiting and create a table with the results
 
3. Find the difference in fastest solve times between competitors who are in their home country vs. visiting and create a table with the results
 
4. Append to the task 1 results the competitor's name and time for both the minimum fast time and the fastest minimum average time and create a table with the results
 
Bonus: Combine all tables with the top 10 country results at the top.
 
Aaron_Harter
11 - Bolide

What a puzzle!

Spoiler
0.PNG
Taz98
5 - Atom

1. Find the ten countries that have hosted the most competitions and how many each one has hosted

 

Workflow & Result :

Taz98_0-1638803574696.png

Taz98_1-1638803776921.png

 

Luke_C
15 - Aurora
Spoiler
Luke_C_0-1638804458331.png

 

balajilolla1
7 - Meteor
Spoiler
Solution Attached
balajilolla1_0-1638807329062.png

 

Mchappell67
8 - Asteroid

For Output 4, my times matched, but the names didn't.  Not sure if an issue with the sample output or my workflow...

 

Spoiler
Mchappell67_0-1638807687300.png

 

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
297.jpg

My solution

Tony_Castillo
8 - Asteroid

Same as others where the output 3 names are different but the times match. Bonus Included

Spoiler
Tony_Castillo_0-1638809642743.png

 

dYoast
8 - Asteroid

I got different names, but the same numbers.

Spoiler
dYoast_0-1638809897082.pngdYoast_1-1638809947902.png

 

Spalders
8 - Asteroid

Not a 100% match with the answer in the Output file.

Spoiler
It could depend if the competitor did their best times in the country being reported or their home country
Spalders_0-1638809996817.pngSpalders_1-1638810097409.png