We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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

bobro
6 - Meteoroid

My first challenge response. 

CharlieS
17 - Castor
17 - Castor
 
petgrap
8 - Asteroid
Spoiler
Challenge 122.JPG
Greg_Murray
12 - Quasar

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
8 - Asteroid

my submission below 

danrh
13 - Pulsar

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

cbrettlockard
7 - Meteor
Spoiler
Pretty standard approach.  Like a few other people, I included the sort tool, even though the data was already pre-sorted.
WC122.PNG
mestevez
8 - Asteroid

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

Spoiler
spoiler.JPG
mestevez
8 - Asteroid