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

dYoast
11 - Bolide

I don't have the same results for average age, but I did include totals for all countries.

Trying a spoiler for the first time.

Spoiler
dYoast_0-1626713034822.png

 

 

ggruccio
ACE Emeritus
ACE Emeritus

Used 8-5-2016 as the start date for the Rio Olympics.

 

Spoiler
Fairly simple separate data calculations - brought back together at the end of the data stream.  ggruccio_0-1626714779837.png

 

achillesjing
7 - Meteor

Here is my solution

mike_w
8 - Asteroid

As a few others have mentioned - I also get results different from the solution provided. Using the CreW Expect Equal Tool reveals the issues, there's a handful or so errors: So for example it says there's a problem in row 23; checking the solution provided, row 23 is Bhutan with 2 Female Athletes, 0 (or [Null]) Male Athletes - and then [Null] Total Athletes!  That can't be right. 

Spoiler
mike_w_0-1626721934626.png

 

Elias_Nordlinder
11 - Bolide

My solution, also get 5 records wrong because not correct value in output given as for other people.

 

Spoiler
Elias_Nordlinder_0-1626723479681.png
Elias_Nordlinder_1-1626723497939.png

 

 

ryan-bush
Alteryx
Alteryx

Fun and timely challenge! '2016-08-05' for the age calculation is a useful tip

Michael_McKee
Alteryx Alumni (Retired)

This was a fun one

phottovy
13 - Pulsar
13 - Pulsar

I don't think I'll make the podium for my time on this one.

 

Spoiler
277.png
kelly_gilbert
13 - Pulsar

I love these summary/fact-finding challenges! Like others, I had a couple of discrepancies in the total athlete counts likely due to null counts for one of the genders (I'm pretty sure my solution is correct).

 

Spoiler
My workflow:
kelly_gilbert_0-1626745062223.png

 


Differences from the solution:
kelly_gilbert_1-1626745150113.png

Fun fact: one of my colleagues is an athlete in this dataset!

Qiu
20 - Arcturus
20 - Arcturus

Thanks for the tip from @Blake , be careful with the age.

Spoiler
challenge_277.PNG