Alteryx Challenge 8 | Aggregate Purchase

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