Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #164: Retail Therapy

tiffany_chen
8 - Asteroid

Fun! The difference between most people's reply and standard solution is that there is same class name with different Department Name in raw data. But after filter there's no difference. So a little change will bring different results.

Spoiler
My solutionMy solutionAnnotation 2019-12-27 102236.png
JMoriarty65
7 - Meteor
Spoiler
JMoriarty65_0-1577474447922.png

Different workflow than the solution, but the answer seems correct.

apabonok
8 - Asteroid

Hi! Here is my solution.

Very similiar to others and the same difference with original solution.

 

challenge_164_apabonok_spoiler.png

Hjardine
8 - Asteroid
Spoiler
Hjardine_0-1577648486097.png
select to make feedback a double, filter for positive feedback >10, summarize to find average rating by class, sort to prepare to be ranked, multi-row formula to rank, filter for top 5
myouree
8 - Asteroid

My solution.

Aswin
8 - Asteroid
 
rmassambane
10 - Fireball
 
ChuyVBabs
8 - Asteroid

Got help from Rufus T. Firefly with this one.

 
Wenhao
7 - Meteor