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

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
8 - Asteroid

My Solution!

Laurap1228
11 - Bolide

Here is my solution. 

Spoiler
Laurap1228_0-1682621253656.png

 

bjkay30
8 - Asteroid
Spoiler
bjkay30_0-1682686258912.png