Challenge #8: Aggregate Consumer Purchases

[Mahofga]

Here is my solution.

[JuBo28]

My solution following along with the Designer Onboarding lesson. :)

[kelseysbooth]

Solved as part of the Designer Onboarding. I made a few decisions that were not optimal, but it was a good learning experience.

[ksiudut]

New to Alteryx, but was able to follow the instructions in the Module 3 guide 😅

[blzebra]

Very challenging for first time!

[GosiaK]

My solution attached

[GosiaK]

My solution attached.

[asljneibi]

The solution uploading

[IsaacMojica]

Hello, Alteryx Community! 

I found some inconsistencies between the webpage and the yxmd file following the challengue objective.

1. Problem Statement misguidance.

• Challenge #8: Aggregate Consumer Purchases

Challengue Webpage states "Please identify the number and percentage of orders since July 1, 2013" While the "challenge_8_start_file.yxzp" hurries you to "identify the number and percentage of orders since June 2013" having two different outcomes. Will leave mine from June 1st, 2013 onwards at the spoilers section.

Other than that, great challenge ot practice after watching all the interactive lessons!

 

Spoiler

-Joined both tables by Desc. Adjusted Datatypes
-Filtered by date
-Added colums with Byte sized values(1,0) for for indating rows that have ("Pizza" OR "Burger"), "Drinks", and "Side"
-Summarized Grouping By Ticket ID and SUM of previously created column's values. 
-Filtering records to achieve Meal Deal Existance Condition dataset.
-Summarized and joined distinct Ticket ID and Count of Meal Deal Tickets by position.
-Calculated the percentage

Results come as follows:

Since July 1, 2013

• Same as solution_file

Since June 1, 2013

• Total Tickets:17977
• Potential_Meal_Deal_Tickets:12751
• Percentage_Potential_Meal_Deal: 70.929521(%)

[Kishori]

Solution for challenge#8