Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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
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.
