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

JITHINPR
8 - Asteroid

my solution

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1626703978703.png

 

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1626704685210.png

 

kunderwood
7 - Meteor

Fun challenge! 

Maskell_Rascal
13 - Pulsar

Is plate throwing really an Olympic sport?

 

Let's discus! 😆

 

Here is my solution:

Spoiler
Maskell_Rascal_0-1626706463941.png

 

Cheers!

Phil

natalie_ruppi
5 - Atom

Fun challenge!

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
277.jpg
My solution.
sukanya_T_P
6 - Meteoroid

My solution

SeanMichael
6 - Meteoroid
Spoiler
SeanMichael_2-1626711467485.png

 

Great Challenge!!!

TonyA
Alteryx
Alteryx

Wasn't clear whether "id" was specific to the athlete so I added a check to make sure that an athlete didn't compete in multiple sports (looking at name, dob, height, and weight). There were bad totals based on adding a number to a null in some rows.

Spoiler
I noticed that the "Total Row" function in Crosstab ignores nulls. I think this is because it totals the values before pivoting, so the null values haven't been created yet.

TonyA_0-1626713497102.png