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 #5: Client Rating Analysis

RWvanLeeuwen
11 - Bolide

Some day we'll be able to use multi-row calcs in Alteryx Cloud :)

 

Until that day comes, here's my approach to finding the "top 3 values" accounting for ties

 

Spoiler
Quest 5 - RWvL.png
OllieClarke
15 - Aurora
15 - Aurora

Nice simple one

Spoiler
Quest_05.png
nadasky
Alteryx
Alteryx

My solution.

 

Spoiler
Quest 5 Solution JN.png

SGolnik
11 - Bolide
11 - Bolide
Spoiler
Quest 5 Screenshot.png
bradshaw
Alteryx
Alteryx

Here's my solution

Spoiler
Screenshot 2024-05-04 at 8.46.59 PM.png
MikeRoof
Alteryx
Alteryx

 

Spoiler
Screen Shot 2024-05-06 at 12.15.12 PM.png

 

 

Shadieht
5 - Atom

How do you convert the file to a .json? I can't find the article on this.

nadasky
Alteryx
Alteryx

To create a .json file, go to the Analytics Cloud home and select the Library tab. Find the workflow you'd like to create a .json file for and then select the vertical ellipses in the far right column. Select Download from the drop down list. This will open a "save file" dialog to save your file.

 

Good luck.

 

 

 

FlorianC
Alteryx
Alteryx
Spoiler
Designer Cloud workflowDesigner Cloud workflow
Florian Carrier
Strategic Solution Consultant
Alteryx
Shadieht
5 - Atom

Here is my result. Great exercise.