top of page
Ed Orlando
Data Scientist | White Lodging
Alteryx Weekly Challenge #8
Aggregate Consumer Purchases
https://community.alteryx.com/t5/forums/recentpostspage/user-id/19037
Objective:
We are thinking of including a new "Meal Deal" on our menu and want to study the potential impact on recent transactions. Identify the number and percentage of tickets since June 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.
Summary of Data:
Point of Sale data includes the ticket level information, and the lookup table categorizes items into higher level food categories.
Hint:
Don't forget to join to the lookup table and filter by date.
Data Set #1 Data Set #2
Workflow with Detail
Final Data Set Solution




















bottom of page