Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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
10 - Fireball
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