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

My first weekly challenge ...

Asteroid

Done!

 

Spoiler
164_Capture.PNG
Meteoroid

My solution is here-

Alteryx Certified Partner

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. 

Asteroid
 
Atom
 
Asteroid

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

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

 

Atom
 
Asteroid

here you go