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

MrSmartyPants
6 - Meteoroid

My first weekly challenge ...

BradWerner
11 - Bolide

Done!

 

Spoiler
164_Capture.PNG
zhuy42
7 - Meteor

My solution is here-

Hannah_Lissaman
11 - Bolide

I spent a while on this one deciding whether to go with what I understood to be the correct answer based on the instructions, or to aim for replicating the example results. I've decided to share my answer with the former option:

Capture.PNG

 

Like many people, I initially struggled to understand the meaning of the 'Positive Feedback Count' field. I checked the source page which Christine kindly provided, which defined this as the number of times an individual piece of feedback has been rated as useful by other users. With that in mind, it made sense to count each piece of feedback with a 'Positive Feedback Count' of 1 or more as a positive feedback review, rather than just filtering to reviews with 10 or more in this field. 

 

The other decision I had to make was whether to include ratings from reviews which had not received positive feedback. I concluded that it made sense to include these, and to consider the 'at least 10 positive feedback reviews' as a test for whether a particular item has been reviewed enough times to have a fair assessment, and that all reviews for these items should be included in the average. 

bkclaw113
9 - Comet
 
ThomasR
6 - Meteoroid
 
AmNotARobot
8 - Asteroid

72 of the results match exactly, 10 do not match across the 4 columns of output. Hmmmm

MacrosGrant
5 - Atom

First Alteryx Challenge complete.

 

Decided to be a bit cheeky and use the filter tool to do 2 things in 1 which meant I only needed to use 4 tools :-)

 

Spoiler
Challenge 164 MacrosGrant.JPG

 

DJStruth
5 - Atom
 
NatSnook
8 - Asteroid

here you go