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

WilliamR
Alteryx
Alteryx

My solution

Spoiler
 

Quest2.pngQuest2Result.png

SeanAdams
17 - Castor
17 - Castor

Very similar solution to most of the other folk.

 

Screenshot 2024-09-07 191756.png

 

image.png

 

 

I'm trying to use the Cloud Native version to get a sense of the capabilities of this - since that's gotta be the future of the platform.

 

 

terry10
12 - Quasar
Spoiler
CQ2.PNG

I used standard mode.

smurfitt
7 - Meteor

From looking at the steps I followed and the solution, it looks like I should have the same results, but obviously my filter is returning more rows as I have different number than expected results.

MeenakshiKumar_
5 - Atom

Hey Everyone! 
Here's my submission.

mzegrodzki
Alteryx
Alteryx
Spoiler
MZ Quest2.png
Carolyn
12 - Quasar
12 - Quasar

Oof, that was rough. The challenge itself wasn't bad but I spent awhile chasing down why I didn't match the solution in the initial post or in Josh's video - I kept thinking I was doing something wrong, built it in Designer Desktop, and even went to Excel as the tiebreaker..... it's that the solution of 14,450 is a Sampled solution, not the full solution

 

The POS initial csv file has 269,375 rows. However, with the sampled solution, you start with 254,750 rows. I finally figured it out when I uploaded someone else's solution, connected it with my data, and saw the 14,450 appear instead of the 15,497 that was on my screen with the exact same file, and felt like my data was messing with me.... nope, just sampled. 

 

FYI @AYXAcademy 

 

Spoiler
2024-11-27_16-31-32.png

2024-11-27_16-48-35.png
LeandraN
Alteryx
Alteryx

A little messy but I got it! 

 

Spoiler
 

 

jiri-peroutka
Alteryx
Alteryx

Done. 

Snímek obrazovky 2025-01-03 v 14.48.46.png

Luke_C
17 - Castor
17 - Castor
Spoiler
 

image.png