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

ChristineB
Alteryx Alumni (Retired)

The solution to last week's challenge can be found HERE

 

Determine the items of clothing that have the highest average rating. In your analysis, include 1) only items of clothing that have at least 10 positive feedback reviews and 2) the five highest rated clothing items from each class.

 

The original data and its metadata can be found here

 

 

 

danilang
19 - Altair
19 - Altair

Fun lunch time challenge.  

 

Spoiler
WF.png

 

Dan

cplewis90
13 - Pulsar
13 - Pulsar

My solution! Fun challenge today! 

Spoiler
@ChristineB if this is correct, the output may be off a bit. Specifically around clothing id = 1119.
Challenge 164.PNG
Kenda
16 - Nebula
16 - Nebula
Spoiler
Somehow one of the outerwear items got switched to jacket in the given output (ID 1119) so my answer differs slightly, but I think what I've done is correct

Capture.PNG
T_Willins
14 - Magnetar
14 - Magnetar

Similar workflow and same results as other responses.  Left in my analysis of finding data discrepancy of Clothing ID 1119 (two divisions names for same product).

 

Spoiler
 Workflow 164.GIF

 

 

NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution! Oh, if only I could actually do my retail therapy shopping on Alteryx from now on...

 

Spoiler
WeeklyChallenge164.JPG

Cheers!

NJ

patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG
MarqueeCrew
20 - Arcturus
20 - Arcturus

@ChristineB,

 

Kudos to @Kenda for checking her work (unlike the other early answering birds).  I am in agreement with her.  

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
13-05-_2019_21-07-39.png
TianyueYang
5 - Atom

Here is my result :).