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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

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

vinalsn
5 - Atom

Solved.

SueDonim
8 - Asteroid

The directions were not as clear as they could be on this one, as it implies you should calculate the average rating before filtering for those with more than 10 positive reviews.  Also some of the items had the same item with different department names.

 

A real world issue of course, but makes matching the answer more difficult

 

Spoiler
Process
- Filter for those with more than 10 positive reviews
- Sort data by rating (descending)
- Group by department, class, and clothing ID
  -- Average rating
- Select ratings (by class) with top 5 ratings

MySolution.PNG
HarshGarg6135
6 - Meteoroid
 
karam
8 - Asteroid

Solution attached.

DBourke1984
8 - Asteroid
Spoiler
Weekly Challenge 164 Solution.PNG

Loving the data analysis style questions - keep them coming!!

justindavis
9 - Comet
Spoiler
challenge_164_solution_justindavis.PNG
CallieYuan
8 - Asteroid

Slow and Steady

Snare
8 - Asteroid

Going through some past beginner challenges and knocked this one out real quick.

blundebjerg
8 - Asteroid
 
OllieClarke
13 - Pulsar
13 - Pulsar

Nice quick one 🙂

Spoiler
Challenge 164.png