In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
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
8 - Asteroid

now with flow

ed_hayter
12 - Quasar

Cloud Quest 2 Complete

 

Spoiler
image.png
TigiPaz
5 - Atom

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

Dlawless610
7 - Meteor

 

 

Cloud#2.jpg

BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

Cool stuff.

 

Spoiler
Screenshot 2024-05-21 at 20-32-19 workflow_20240521_201235 Workflows.png

BS

All the best,
BS

LinkedIN

Bulien
Tom_Pilgrem
8 - Asteroid

Here's my solution 

 

Spoiler

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.

 

Spoiler
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
11 - Bolide

A fun one!

Spoiler
Screenshot 2024-05-30 141604.png

phottovy
13 - Pulsar
13 - Pulsar

Quest #2 complete!

 

002.png