Free Trial

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 #332: The more ice cream, the better!

Yogesh1795
8 - Asteroid

wasted time in removing unwanted characters from the description column, realized that I don't need it to solve this problem.
Anyways, will come back to this, so that I can learn how to remove codes between text.
Easy exercise

nSpire
9 - Comet
Spoiler
nSpire_0-1682363916579.pngnSpire_1-1682363944267.pngnSpire_2-1682363964588.png

 

JennyRuns24
8 - Asteroid

Solution provided.

NickRogers
8 - Asteroid

My solution

Swathi
9 - Comet

Solution here

mgaronson
11 - Bolide

mgaronson_1-1682593875154.png

 

Thanks to EMEA group at JLL for teaching me how to exclude non-printable Ascii characters in Regex even though it was not strictly required for the challenge.

Question 1 - First one matches the solution which calculates an average of averages. Second one takes the Sum(ratings * rating count)/Sum(rating count)

Deborah_Simmonds
8 - Asteroid

Really fun challenge, learned some new Regex as a team, and inspired great conversation re: should we be averaging averages?

Loved this!

SmitaLohande
9 - Comet

My Solution!

Laurap1228
11 - Bolide

Here is my solution. 

Spoiler
Laurap1228_0-1682621253656.png

 

bjkay30
8 - Asteroid
Spoiler
bjkay30_0-1682686258912.png