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.

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 #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
8 - Asteroid

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
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1637595186656.png

 

Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1637595474173.png

 

balajilolla1
6 - Meteoroid
Spoiler
Solution Attached

balajilolla1_0-1637596214057.png

 

chukleswk
9 - Comet
Spoiler
Capture.PNG

This one was a fun one with the holidays approaching!

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
295.jpg
CHarrison
8 - Asteroid

My solution 😄 

alexnajm
8 - Asteroid

Happy Thanksgiving everyone!

Spoiler
challenge_295_start_file_Alex Abi-Najm.PNG