Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #3: Ranking Duplicate Data

AYXAcademy
Alteryx
Alteryx

Academy_Quests_Banner_1050 x 300 (1050 x 200 px) (1).png

 

 

 

Hi Maveryx,

 

Thanks for submitting your solutions for Cloud Quest #2! In the video solution we posted, Alteryx Chief Evangelist Josh Burkhow will guide you through the workflow.

 

Now, for this week’s quest, let's delve into the task of ranking records when there can be multiple records with the same rank.

 

Using the provided dataset that contains two columns [Name] and [Count], your goal is to identify the top five rankings based on the count. However, as there might be several rows with identical counts (similar to a round of golf), multiple individuals can occupy the same position (Rank) if they share the same score.

 

Your final result should look like the following image:

Output.png

 

Hint: Identify the top five positions (ranks 1 through 5) based on the Count column before proceeding with your analysis.

 

Spoiler

A combination of Join, Summarize, Sample, Row ID, and Sort tools should solve your problem, not necessarily in this sequence.

If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance:

 

Here’s to a successful quest!

 

We want to hear from you!

As we introduce our Cloud Quests for the first time, we value your input. Share your thoughts on the clarity of instructions, the provided dataset, the expected output, and any suggestions to enhance your experience.

 

Thank you!

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

 

 

47 REPLIES 47
alexnajm
16 - Nebula
16 - Nebula

@AYXAcademy can we get a sample file? 😊

RobertW
Alteryx
Alteryx

I generated my own input based on the description and the output.

 

Spoiler
Screen Shot 2024-03-06 at 2.25.31 PM.png
teddim
Alteryx
Alteryx

Here is my solution:

Spoiler
ayx-quest3.png

Qiu
20 - Arcturus
20 - Arcturus

@AYXAcademy 
It will better we have the dataset as input. 😁

ScottMcV
Alteryx
Alteryx

You're sort of an overachiever.

ScottMcV
Alteryx
Alteryx

This was aimed at Rob, although I understand why he did what he did :)

ScottMcV
Alteryx
Alteryx

ADDENDUM: Rob says I'm a cheater and I can't just eyeball the top five values. So I hope I'm "tweaking" it to his approval using a variation on what I was doing to return only the top five groupings.  

 

PRIOR:

I also created my own dataset, although I assume the intent was to "summarize" data, not start with it summarized, so I sort of cheated by skipping that step.  Realized my description was potentially a spoiler, so edited.

 

Spoiler
CloudQuest3.png

 

Spoiler
CloudQuest3.png

 

ScottMcV
Alteryx
Alteryx

And yes, I did make Rob the winner.

RWvanLeeuwen
11 - Bolide

Hi everyone,

 

I used Designer Desktop to create a dataset we can use for this Quest

quest3 data creation RWvL.png

Please use this to rank how many Trump tweets these people favourited and ensure you follow the quest guidelines