Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start 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
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

 

Révélation
Quest 5 - RWvL.png
OllieClarke
16 - Nebula
16 - Nebula

Nice simple one

Révélation
Quest_05.png
nadasky
Alteryx
Alteryx

My solution.

 

Révélation
Quest 5 Solution JN.png

SGolnik
11 - Bolide
11 - Bolide
Révélation
Quest 5 Screenshot.png
bradshaw
Alteryx
Alteryx

Here's my solution

Révélation
Screenshot 2024-05-04 at 8.46.59 PM.png
MikeRoof
Alteryx
Alteryx

 

Révélation
Screen Shot 2024-05-06 at 12.15.12 PM.png

 

 

Shadieht
Atome

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
Révélation
Designer Cloud workflowDesigner Cloud workflow
Florian Carrier
Strategic Solution Consultant
Alteryx
Shadieht
Atome

Here is my result. Great exercise.