Challenge #297: Rubik Cube
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AYXAcademy
Alteryx
12-06-2021
06:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
Aaron_Harter
11 - Bolide
12-06-2021
07:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What a puzzle!
Taz98
5 - Atom
12-06-2021
07:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Luke_C
17 - Castor
12-06-2021
07:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
balajilolla1
8 - Asteroid
12-06-2021
08:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Solution Attached
Mchappell67
9 - Comet
12-06-2021
08:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For Output 4, my times matched, but the names didn't. Not sure if an issue with the sample output or my workflow...
RolandSchubert
16 - Nebula
12-06-2021
08:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution
Tony_Castillo
9 - Comet
12-06-2021
08:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Same as others where the output 3 names are different but the times match. Bonus Included
dYoast
11 - Bolide
12-06-2021
08:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I got different names, but the same numbers.
Spalders
8 - Asteroid
12-06-2021
09:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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