Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #2: Consumer Purchase Aggregation

JJungers
Alteryx Alumni (Retired)

I enjoyed this one! Here's my solution.

 

Diederik_vanderharst
アステロイド

now with flow

ed_hayter
パルサー

Cloud Quest 2 Complete

 

スポイラ
image.png
TigiPaz
アトム

I could not get mine to work with (==) but found a way using Boolean language.

Dlawless610
メテオール

 

 

Cloud#2.jpg

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Cool stuff.

 

スポイラ
Screenshot 2024-05-21 at 20-32-19 workflow_20240521_201235 Workflows.png

BS

All the best,
BS

LinkedIN

Bulien
Tom_Pilgrem
アステロイド

Here's my solution 

 

スポイラ

Quest 2 Solution.png

mceleavey
17 - Castor
17 - Castor

Second one in the books.

I think it's unfair doing these challenges while being distracted by @joshuaburkhow 's face on the first page.

 

スポイラ
Workflow.png
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.

Results.png


Bulien

Towers
ボリード

A fun one!

スポイラ
Screenshot 2024-05-30 141604.png

phottovy
13 - Pulsar
13 - Pulsar

Quest #2 complete!

 

002.png