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

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #122: Think Like a CSE...Ranking Data

bobro
メテオロイド

My first challenge response. 

CharlieS
17 - Castor
17 - Castor
 
petgrap
アステロイド
スポイラ
Challenge 122.JPG
Greg_Murray
クエーサー

I love a good muliti-row tool.

MarqueeCrew
20 - Arcturus
20 - Arcturus

@JohnPo,

 

I thought that I was clever and see that while @NicoleJohnson was first she included a SELECT tool that made her solution readable, but added 33% more tools to the canvas.  @patrick_digan and others used the RECORD ID with the desired MTRank name to minimize tools on the canvas.  Coming to this party a day late, I was glad to be invited.  Sorry that I brought the same gift.

 

PutItOverThereWithTheOthersGreaseball.gif

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
badiualex
アステロイド

my submission below 

danrh
パルサー

And here I thought I was being sneaky using RecordID.  I'll lean on that whole "Great Minds" adage.

cbrettlockard
メテオール
スポイラ
Pretty standard approach.  Like a few other people, I included the sort tool, even though the data was already pre-sorted.
WC122.PNG
mestevez1
アステロイド

This is my second challenge. Learning from the community members...

スポイラ
spoiler.JPG
mestevez1
アステロイド