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

Atom

Solved.

Alteryx Partner

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
Meteoroid
 
Alteryx Certified Partner

Solution attached.

Meteor
Spoiler
Weekly Challenge 164 Solution.PNG

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

Asteroid
Spoiler
challenge_164_solution_justindavis.PNG