Top 3 Guilt-Free Candies for 2024

In this challenge, I aimed for a simple and minimalistic dashboard. I utilized just one chart to identify the top three candies for Halloween. The database includes 85 different types of candies, providing information on win percentage, sugar and price percentiles, flavor types, and candy types.

My report features a scatter chart that differentiates between low and high prices as well as popular and unpopular candies. The bubble sizes indicate sugar content, while the colors represent the candy flavors.

My primary focus was not only to identify the top candies based on win percentage but also to highlight the top three options that are both healthy and affordable. Although there are several candies with high win percentages, such as Twix, Reese's Peanut Butter, and Snickers, they do not meet the criteria for being healthy or affordable.

I have added a extra column for Category, to help me create in scatter chart.

Category = 
   IF([chocolate] = 1 && [caramel] = 1 && [peanutyalmondy] = 1 && [nougat] = 1 && [crispedricewafer] = 1, 
      "Chocolate, Caramel, PeanutAlmondy, Nougat, CrispedRiceWafer",
   IF([chocolate] = 1 && [caramel] = 1 && [peanutyalmondy] = 1 && [nougat] = 1, 
      "Chocolate, Caramel, PeanutAlmondy, Nougat", 
   IF([chocolate] = 1 && [caramel] = 1 && [peanutyalmondy] = 1, 
      "Chocolate, Caramel, PeanutAlmondy", 
   IF([chocolate] = 1 && [caramel] = 1, 
      "Chocolate and Caramel", 
   IF([chocolate] = 1 && [fruity] = 1, 
      "Chocolate and Fruity", 
   IF([chocolate] = 1, 
      "Chocolate", 
   IF([fruity] = 1, 
      "Fruity", 
   IF([caramel] = 1, 
      "Caramel", 
   IF([peanutyalmondy] = 1, 
      "PeanutAlmondy", 
   IF([nougat] = 1, 
      "Nougat", 
   IF([crispedricewafer] = 1, 
      "CrispedRiceWafer", "None"
   )))))))))))

Also added an another column for Candy type whether it is bar, hard or pluribus.

Thank you.