Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #164: Retail Therapy

Highlighted
Alteryx
Alteryx

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

 

 

 

Highlighted
17 - Castor
17 - Castor

Fun lunch time challenge.  

 

Spoiler
WF.png

 

Dan

Highlighted
12 - Quasar
12 - Quasar

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
Highlighted
14 - Magnetar
14 - Magnetar
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
Highlighted
13 - Pulsar
13 - Pulsar

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

 

 

Highlighted
14 - Magnetar
14 - Magnetar

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

 

Spoiler
WeeklyChallenge164.JPG

Cheers!

NJ

Highlighted
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@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 reboot. Order shall return.
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Spoiler
13-05-_2019_21-07-39.png
Highlighted
5 - Atom

Here is my result :).