Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #164: Retail Therapy

TonyA
Alteryx Alumni (Retired)

Here's my solution.

mbogusz
9 - Comet
@Carlithian I'm assuming the Positive Feedback Reviews represent the total number of other positive reviews for different products the reviewer has given.  That helps to eliminate if a reviewer account was newly created for the sole purpose of ramping up the average rating of the product. Their methodology is giving more credibility/weight/heft to the reviewers having reviewed more than one product and filters out the possible 'noise' reviewers/reviews.
 
Spoiler
Challenge 164 Solution.png
jamielaird
14 - Magnetar

Voilà mon solution

 

Spoiler
Screenshot 2019-06-23 at 21.13.39.png
SeanAdams
17 - Castor
17 - Castor

Got a slightly different answer on one category than @ChristineB - but the rest matched.

Good exercise in data prep and cleaning!

 

Minor differenceMinor difference

 

Spoiler

Solution.png

bnelly1987
8 - Asteroid

Not too bad!

Spoiler
Solution-Challenge 164.PNG
knhinson
6 - Meteoroid

Probably not the fastest way to arrive at the solution, but it works! 

Spoiler
Challenge 164.PNG
shoesnsocks4
7 - Meteor
Spoiler
Spoiler

ac164.PNG

Originally made it harder that it needed to be.  Fun one!

leena_suva
6 - Meteoroid
Spoiler
Spoiler Alert #164.JPG
wwatson
12 - Quasar

My solution

brampauwels
5 - Atom

Here's mine. I've tried both of the most common approaches. It seems that the below *spoiler* is the only way to work around the 'ID1119 issue'. Still not quite sure how and why... Happy to hear your feedback.

 

Spoiler
Spoiler

Schermafbeelding 2019-06-25 om 21.41.53.png