Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #295: Thanksgiving Feast

AYXAcademy
Alteryx
Alteryx
Weekly Challenge Image 300 (1).pngA solution to last week’s challenge can be found here
 
The Thanksgiving Holiday in the US involves a lot of food! Let's take a closer look at what people typically serve in different US regions. 
 
The dataset contains information about what type of dishes are served at Thanksgiving dinners in US households, including type of protein, cranberry, if they use gravy or not, type of sides, pies and dessert, and in which regions they are. Each row of the dataset corresponds to one household. The challenge is to:
 
Task 1
Find the total number of food dishes (protein, cranberry, gravy, sides, pies and dessert) served in each household. 
 
Task 2
Find the average number of dishes served for each US region.
 
Task 3
Determine the total number of pies served for each US region and create a pie chart to show the results in percentage. 
 
BONUS:
What is the most popular combination of side dishes and how many households are serving it?
 
Data source:
alexnajm
17 - Castor
17 - Castor

I'm not seeing an input file in the Alteryx Package. Can you re-post it by chance?

challenge_295_issue.PNG

AYXAcademy
Alteryx
Alteryx

Thanks for letting us know! The file was updated!

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1637595186656.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1637595474173.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1637596214057.png

 

chukleswk
11 - Bolide
Spoiler
Capture.PNG

This one was a fun one with the holidays approaching!

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
295.jpg
CHarrison
8 - Asteroid

My solution 😄 

alexnajm
17 - Castor
17 - Castor

Happy Thanksgiving everyone!

Spoiler
challenge_295_start_file_Alex Abi-Najm.PNG