Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
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
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.