Challenge #164: Retail Therapy

[hbraunius]

My solution attached.

[erick_irigoyen]

Including my response

[jasperlch]

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. 

[badiualex]

My solution below

Spoiler

[LukeM]

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

Cheers @ChristineB !

[sprodger]

My Solution:

Spoiler

[DataRangler]

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

[Abhi2019]

Here is the solution!

[ewelch531]

solution attached

[Reesetrain2]

All,

Here is my solution!

-The Multi-Row Formula really comes in handy!

Spoiler

Spoiler

-Cheers!

Matt