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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #164: Retail Therapy

Asteroid

My solution attached.

Including my response

Quasar

Solution attached.

 

Looks like the item with Clothing ID = 1119 is causing some issues as there are items with different Class Names with this ID. 

Meteor

My solution below

Spoiler
image.png

 

Alteryx
Alteryx

A very good test of understanding of data and translation of written requirements. Once that's solved, a nice simple alteryx solution.

 

Cheers @ChristineB !

Asteroid

My Solution:

 

Spoiler
challenge_164_solution_SP.JPG
Alteryx Partner

Seems that if we are taking the top 5 rated clothing items (Department-Class) and the 5th rating is the same as the 6th and/or the 7th ect.. These should be included, unless an new criteria is established for ranking.

D           C               C_ID   R RunTot Include
Jackets Outerwear 1117    5     1         1
Jackets Outerwear 1119    5     2         1
Jackets Outerwear 1132    5     3         1
Jackets Outerwear 1121    4.6  4         4
Jackets Outerwear 1115  4     5         5
Jackets Outerwear 1123  4     6         5
Jackets Outerwear 1131  4     7         5
Jackets Outerwear 1116    3     8         8
Jackets Outerwear 1128    3     9         8
Jackets Outerwear 1127    2   10       10
Jackets Outerwear 1122   1.5 11        11

 

Atom

Here is the solution!

Meteor

solution attached

Asteroid

All,

 

Here is my solution!

-The Multi-Row Formula really comes in handy!

Spoiler
SpoilerChallenge164.png

 

-Cheers!

Matt