alteryx Community

# 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.

## Challenge #297: Rubik Cube

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

Many 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.

11 - Bolide

What a puzzle!

Spoiler
5 - Atom

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

Workflow & Result :

17 - Castor
Spoiler

8 - Asteroid
Spoiler
Solution Attached

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

16 - Nebula
Spoiler

My solution

9 - Comet

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

Spoiler

11 - Bolide

I got different names, but the same numbers.

Spoiler

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