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
8 - Asteroid

Done ! 

Highlighted
5 - Atom

Fun challenge although I wish the objective was worded differently... The solution was expecting you to only include items that at least 10 other customers marked as helpful whereas I was led to believe that any item marked as helpful to another customer (i.e.: Positive Feedback Count greater than 0 indicated a positive feedback review) was to be included. Took me forever to understand that!

Highlighted
7 - Meteor

Here is my solution !!!

Spoiler
#164 - Solution - PS.JPG
Highlighted
9 - Comet

My solution.

 

Spoiler

bmcclelland46_0-1597244006252.png

 

Highlighted
8 - Asteroid

.

Highlighted
Alteryx Partner

Solution Attached

Highlighted
11 - Bolide

Not difficult one

Spoiler
en-164.PNG
Highlighted
Inactive User
Not applicable

Here is a different solution from my end

Highlighted
6 - Meteoroid
Spoiler
 
Highlighted
8 - Asteroid

I should've read some of the other solutions before comparing results as it would've saved me time in researching the discrepancy. But, since I spent the time researching the difference I'll go ahead and provide my assessment in hopes of saving time for others.

 

The 'discrepancy' of clothing id is actually an issue with the provided solution. As shown below in the first spoiler, the Unique tool is pulling from the pre-filtered data set. This then joins the unique prefiltered data with the average ratings, thereby re-adding the clothes with < 10 positive feedback count. Therefore, the provided end results are incorrect and Clothing ID 1119 under Class Name Jackets should not be in the final results. Instead, ID 1119 responses from Class name Outerwear should be included.

 

Spoiler
TC_bot_0-1599922339707.png
TC_bot_1-1599922801464.png

 

 

The below is shows the correct results.

Spoiler
TC_bot_2-1599923201131.png