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.
alteryx Community

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 #279: How many Olympic Games per Continent?

Alteryx

A solution to last week’s challenge can be found here.

This week's challenge is relatively straightforward, but sometimes data needs trimming.

The following dataset includes a list of city, country, year, continent, and season (winter or summer)

for each Olympic Games except those canceled.

- How many times has each continent hosted the Summer Olympics?
- How many times has each continent hosted the Olympic Winter Games?
- What is the total of the Olympic Games hosted for each continent, summer and winter combined?

Oh, easy, you may think. For this Challenge, you will have to propose 2 solutions and one that does not use the trim functions.

11 - Bolide

Let the games begin!

Spoiler

(edit 8/2 9:35 CT) video of solution overview, with discussion and build out of data 'trimming' options:

Spoiler

20 - Arcturus

My take on the weekly challenge

Spoiler

Cheers and Happy analyzing 😀

Have a great week 🙂

12 - Quasar

I just can't believe they don't include Korfball and Tug of War as Olympic sports anymore. Such a shame.

Spoiler
15 - Aurora

My solution

Spoiler
15 - Aurora
Spoiler
Technically it says one solution should not use the trim function, therefore if neither of my solutions use it, I am still following the rules 😏

9 - Comet

Add one for the summer count!

Spoiler
12 - Quasar

My 2 solutions :

Spoiler

8 - Asteroid
Spoiler

14 - Magnetar

My Solution without using Trim attached,

Spoiler

And in Python,

Spoiler

,