We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #291: A Winning Halloween Candy Basket

Alteryx

Pumpkins abound, and squirrels are happy. It’s that time of the year! Halloween is in just a few days, and you need to get candy for trick-or-treaters.

This Halloween dataset contains 85 types of candy. Take a closer look at the columns:
- sugar percentage - The percentile of sugar it falls under within the data set.
- price percentage - The unit price percentile compared to the rest of the set.
- favorite percentage - The overall win percentage according to 269,000 matchups.

- The 5 candies with the lowest “sugar percentage”. An average trick or treater consumes 7,000 calories worth of candy, so you want to offer some healthy options.
- The 5 candies with the highest “favorite percentage”. Your neighbors know you are a people pleaser!
- The 5 candies with the lowest “price percentage”. The giant tarantula inflatables you bought weren’t cheap, so you need to save some money on the treats.

And no peanut or almond candies.
The teal pumpkins at your front door communicate that your candy basked is allergy-friendly. (Did you know that’s a “thing”?)

Hint

Make sure to filter out all candies that are not allergy friendly first.

Among the 85 types of candy from the dataset, what are the 15 candies to have in your basket?

16 - Nebula

My solution.

Spoiler

16 - Nebula
Spoiler

6 - Meteoroid

A solution to Challenge 291.

Spoiler
17 - Castor
Spoiler

13 - Pulsar
Spoiler
13 - Pulsar

I did not know there were even "teal" pumpkins, let alone that they help prevent allergic reactions. Very cool!

Spoiler
8 - Asteroid
Spoiler

Here is my submission.

9 - Comet

Glad this Weekly Challenge was a treat and not a trick🍬

Spoiler

16 - Nebula
Spoiler

My solution.