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

lzk222
5 - Atom

My solution.

Spoiler

Screenshot 2022-01-02 145253.png

 

Like others, I had name differences. Perhaps I'm misunderstanding the questions, but I believe the issue is that the official solution selects the top sample from the "country1" name associated with the competition event, rather than the competitors nationality. For instance, for average best time should be Dario96 (7.25) instead of Carlos117 (7.38).

 

The official solution appears to incorrectly have Carlos117 selected over Dario96 because sampling top competitor by country occurs on the "country1" column (competition nation), not  "competitor_nationality". In that instance country Andorra is associated with Dario96 (even though he is from Spain). Might be some kind of join issue here. Therefore, Carlos117 get's selected as the first Spain name when it should be Dario96. This is okay for most instances since competition nation and top competitor happen to align frequently, but this doesn't work all the time. At the very least, this accounts for the discrepancies that I have encountered. Please let me know if I've missed something. See image. Screenshot 2022-01-02 145941.png

 

messi007
14 - Magnetar

Hello,

 

Below my solution :

 

Spoiler
messi007_0-1641218967099.png

 

PhilipMannering
14 - Magnetar
14 - Magnetar
Spoiler
PhilipMannering_0-1641240677786.png

 

TimothyH
Alteryx
Alteryx
Spoiler
TimothyH_0-1641243956205.png

 

juliabarale002
8 - Asteroid

😎

hayleematecko
7 - Meteor

Loved this one!

CPundir
7 - Meteor

Used Find & replace tool instead of Join to simply the workflow.

johnzrgu75
7 - Meteor

johnzrgu75_0-1641436796071.png

 

scoles0617
8 - Asteroid

My solution

OllieClarke
14 - Magnetar
14 - Magnetar

Here's my solution:

Spoiler
OllieClarke_0-1642430991467.png