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.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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 #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
6 - Meteoroid

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

 

Spoiler
277 solution.PNG
aluthra
7 - Meteor

Challenge #277: 2016 Summer Olympics - solved!

 

aluthra_0-1626966563162.png

 

cchandler21
Alteryx
Alteryx

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_B
Alteryx
Alteryx
Spoiler
Thomas_B_0-1626982785141.png

 

alexnajm
8 - Asteroid

Let the games begin!

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