Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #8: Aggregate Consumer Purchases

Mahofga
5 - Atom

Here is my solution.

JuBo28
7 - Meteor

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

 

 

Challenge8Solution.jpg

kelseysbooth
5 - Atom

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

ksiudut
6 - Meteoroid

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

blzebra
7 - Meteor

Very challenging for first time!

GosiaK
7 - Meteor

My solution attached

GosiaK
7 - Meteor

My solution attached.

asljneibi
7 - Meteor

The solution uploading

IsaacMojica
7 - Meteor

Hello, Alteryx Community! 

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

 

1. Problem Statement misguidance.

 

image.png

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
 

image.png
-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
8 - Asteroid

Solution for challenge#8