Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## 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

22 - Nova

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
16 - Nebula

My solution

Spoiler
16 - Nebula
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

19 - Altair
Spoiler

16 - Nebula

My Solution without using Trim attached,

Spoiler

And in Python,

Spoiler

,