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 currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.https://commons.wikimedia.org/wiki/File:Olympic_rings_without_rims.svghttps://commons.wikimedia.org/wiki/File:Olympic_rings_without_rims.svg


As we gear up for the 2021 Summer Olympics, let's take a look back at the countries and athletes that participated in the last Summer Olympics.

- The "athletes" dataset contains data about the athletes who competed in the 2016 Summer Olympics in Rio de Janeiro.
- The "countries" dataset contains the International Olympic Committee country code.

Find the following for each country:
- The sport with the most athletes
- The total number of athletes
- The total number of female athletes
- The total number of male athletes, and
- The average age of all athletes for each country

 

 

PhilipMannering
14 - Magnetar
14 - Magnetar

Sprint finish.

 

Spoiler
PhilipMannering_0-1626699536020.png

Looks like there's a few erroneous nulls in the solution. This will be because a number + Null() = Null(). Gotta zero those nulls first. 

Aaron_Harter
11 - Bolide

Let the games begin!

Spoiler
0.PNG
Blake
12 - Quasar

Made sure to use the start date for the Rio Olympics when calculating the athlete's ages.

 

Spoiler
277.png

 

 

 

jferrone
8 - Asteroid

Solution to this week's challenge is attached. Age calculation is a bit unclear, but appears to be based on 2016-08-05. I copied that item from @Aaron_Harter  solution. 

 

Spoiler
jferrone_0-1626701318359.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1626701558424.png

 

JasonHu
8 - Asteroid

Here is my submission; you need to find out the average age in the year 2016!

Spoiler
workflow.png
Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1626702026315.png

 

DeanWest
9 - Comet

 

Fun challenge! 😀

Spoiler
challenge_277_solution_DeanWest-snippet.jpg
Jishnu_K
8 - Asteroid

Good