Hi @ChristineB,
First time posting a solution (attached)!
I did have a couple of questions though:
1. As others stated, I got some strange results with clothing ID 1119. From my research into the data set it appears to be due to it being label with a different class. What is the best practice solution here for rectifying this. I am new enough in my Alteryx journey that I having difficulty understanding what the answer is here.
2. In my solution, the listed solution, and the general consensus, you use a filter to include [Positive Feedback Count] >= 10. Because this appears to be so unanimous (including my own) I think it is correct but I did want to clarify my understanding. My understanding of the field is that each time a review has the positive Boolean (=1) it adds another +1 to count. Essentially, from the 9th positive review to the 10th, it will add one to the count. Wouldn't this mean that we are only including a fraction of the reviews within the solution? I.e., we are only including the reviews from 10 on, thereby missing 9 reviews that I believe should be included within the data set.
I am too new to the program to have thought out what the solution would be and am definitively not sure what formula would be but I would think it would be something along the lines of IF positive feedback > 10 then average all reviews for that clothing ID else do no include. This is as opposed to only including the reviews that happened AFTER the 10th one. Would love some feedback here (if anyone is still checking on this one) as I am super curious what the explanation is :)
