Cloud Quest #2: Consumer Purchase Aggregation
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Maveryx,
Thanks for submitting your solutions for our first official Cloud Quest! In the video solution we posted, Alteryx Chief Evangelist, Joshua Burkhow (@joshuaburkhow) will guide you through the workflow (scroll down the page to locate the video).
Thank you, Josh, for the exceptional guidance!
For this week’s quest, you are taking on the role of a restaurant manager. You want to review customer purchase behavior to decide whether your restaurant should offer a meal deal that would add a side and drink to a pizza or burger purchase. To make this decision, you need to study recent transactions to determine the potential impact it could have.
The Point of Sale dataset includes the ticket-level information, and the two lookup tables categorize items into higher-level food types.
Your task is to determine the percentage of orders since July 1, 2013, that include the Food category (Pizza or Burger) paired with a Side AND Drink. To accomplish this, you need to determine the total number of orders placed within the specified timeframe and identify those that meet the criteria for the potential meal deal you are considering for your menu.
Hint 1: Remember to combine the dataset with the lookup tables and filter by date.
Hint 2: Remember to account for dates after June 30, 2013 to include July 1, 2013 in the output.
Your final result should look like the following image:
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance:
- Getting Started with Designer Cloud
- Building Connections in Designer Cloud
- Building Your Workflow in Designer Cloud
Once you have completed this quest, capture a screenshot of your finalized workflow in Designer Cloud and attach the image of your solution to a comment on this post.
Here’s to a successful quest!
SOLUTION
We want to hear from you!
As we introduce our Cloud Quests for the first time, we value your input. Share your thoughts on the clarity of instructions, the provided dataset, the expected output, and any suggestions to enhance your experience.
Thank you!
- Labels:
- Basic
- Data Preparation
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I enjoyed this one! Here's my solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I could not get mine to work with (==) but found a way using Boolean language.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Second one in the books.
I think it's unfair doing these challenges while being distracted by @joshuaburkhow 's face on the first page.
So, I brought the files in and joined them together, keeping the Point of Sale dataset as primary. I then ensured the Date field was assigned the correct data format, then filtered to only show those orders since 2013-07-01. I then counted the total orders along one stream, and on another stream filtered it down to the orders that contained Pizza or Burger and had a side and a drink. Appended these to values together and calculated the percentage of the total orders. Simple.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A fun one!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Quest #2 complete!