community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #164: Retail Therapy

Sr. Instructional Designer
Sr. Instructional Designer

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
Nebula

Fun lunch time challenge.  

 

Spoiler
WF.png

 

Dan

Bolide

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
Pulsar
Pulsar
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
Comet

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

 

 

Magnetar
Magnetar

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

 

Spoiler
WeeklyChallenge164.JPG

Cheers!

NJ

Spoiler
Capture.PNG
Alteryx Certified Partner
Alteryx Certified Partner

@ChristineB,

 

Kudos to @BarnesK 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.
Alteryx Certified Partner
Spoiler
13-05-_2019_21-07-39.png

Here is my result :).