Free Trial

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 #277: 2016 Summer Olympics

izamryan
8 - Asteroid

https://en.wikipedia.org/wiki/2016_Summer_Olympics

gives the Rio summer olympics as opening on 5 August 2016, or '2016-08-05'

 

Spoiler

 

I noticed that two athletes were being mis-calculated as having a date of birth in the future, so I ran the age calculation twice : once to fix everyone's and identify the two mis-calculations, then again a second time after manually fixing the two errant dates.

 

I noticed the provided solution gives a different average age of athletes for the two affected countries (Australia and New Zealand, maybe the dates down under work differently? LOL?). I'm going to consider this as an Easter Egg hidden for us Alteryx-ians!

 

izamryan_0-1626952985756.png

 

 

marctowler
7 - Meteor

Got caught out with the nulls for a few minutes but fixed it

 

Spoiler
277 solution.PNG
aluthra
8 - Asteroid

Challenge #277: 2016 Summer Olympics - solved!

 

aluthra_0-1626966563162.png

 

cchandler21
Alteryx Alumni (Retired)

Please see solution attached

MJ
8 - Asteroid

Anyone else do a Medal Count for extra credit? 😀

 

Spoiler
MJ_Solution.jpg
bjkay30
8 - Asteroid

Here's my take

 

Spoiler
bjkay30_0-1626978608482.png

 

Laurap1228
11 - Bolide

Here is my solution. I tried to use as few tools as possible.

Spoiler
Laurap1228_0-1626981943646.png

 

Thomas_W
8 - Asteroid
Spoiler
Thomas_B_0-1626982785141.png

 

alexnajm
17 - Castor
17 - Castor

Let the games begin!

Spoiler
challenge_277_start_file_Alex Abi-Najm.PNG
kglearner
7 - Meteor
Spoiler
Weekly Challenge 277.PNG