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.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

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
18 - Pollux
18 - Pollux

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
15 - Aurora
15 - Aurora
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
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

 

 

NicoleJohnson
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

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG
MarqueeCrew
19 - Altair
19 - Altair

@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.
Please Subscribe to my youTube channel.
RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
13-05-_2019_21-07-39.png
TianyueYang
5 - Atom

Here is my result :).