Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution following along with the Designer Onboarding lesson. :)
Hello, Alteryx Community!
I found some inconsistencies between the webpage and the yxmd file following the challengue objective.
1. Problem Statement misguidance.
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!
-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
Since June 1, 2013