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

karlhansen
9 - Comet
Spoiler
solution_279.jpg

Obviously you need to close the container you do not want to process, or you will double up your numbers.

gerda
8 - Asteroid
Spoiler
challenge 279.png

Here's the solution!

ZacharyRyanTIL
8 - Asteroid

solved

TungThanhHo
8 - Asteroid

my solution

JoachimCaronTIL
8 - Asteroid

Here are my 2 solutions :

 

Spoiler

- one using regex to cleanse the continent field

- the other one using a replace function (in formula tool) to cleanse the continent field

 

 

Cheers

dougbaron
8 - Asteroid
Spoiler
In the first (top) solution, I used the "trim" function to isolate the continents. In the second (bottom) solution, I used the "contains" function to compare and replace continent names.

douglaspbaron_0-1669613087308.png

 

RWvanLeeuwen
11 - Bolide

Why should I use the Trim() function if I have access to

Spoiler
regex
Spoiler
279.png
SkomantasTamulaitis
8 - Asteroid

Here's my solution.

Spoiler
Screenshot 2022-11-30 094416.png
Liusaidhowen
8 - Asteroid

My solution

NabilahLoti
8 - Asteroid

My answer is bit different with the provided output.

For example for Europe in the provided output get 34 of record. Should it be group by continent & count distinct by year?

NabilahLoti_1-1670484501198.png

 

Spoiler
image.png