alteryx Community

# 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.

## Challenge #8: Aggregate Consumer Purchases

5 - Atom

Here is my solution.

5 - Atom

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

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.

6 - Meteoroid

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

7 - Meteor

Very challenging for first time!

7 - Meteor

My solution attached

7 - Meteor

My solution attached.

7 - Meteor

7 - Meteor

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!

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(%)

8 - Asteroid

Solution for challenge#8