Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #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
15 - Aurora
15 - Aurora

Hello,

 

Below my solution :

 

Spoiler
messi007_0-1641218967099.png

 

PhilipMannering
16 - Nebula
16 - Nebula
Spoiler
PhilipMannering_0-1641240677786.png

 

TimothyH
Alteryx
Alteryx
Spoiler
TimothyH_0-1641243956205.png

 

juliabarale002
8 - Asteroid

😎

hayleematecko
8 - Asteroid

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
15 - Aurora
15 - Aurora

Here's my solution:

Spoiler
OllieClarke_0-1642430991467.png