Rank Macro Examples

[SamDesk]

Hello Community,

Does anyone have some rank macros that they have come across and would be willing to share?

I need to perform a rank calculation for my workflow but just wondering if what I need might already be out there.

Comic Tax

Cheers, 

Sam

[jrgo · Accepted solution]

@SamDesk 

This is a general setup for adding a rank value to a dataset:

The value used to sort is really based on your business needs.

[DiganP · Accepted solution]

@SamDesk Have you searched the gallery repository of workflows/macros? I found some in there that could be useful. 

For ex: Ranking with the blog post.

[cliffjordan]

Sam, 

Here is a Rank macro that ranks columns within the same record. A little different, but often I have found the need for it.

Here are the details:

"RankMacro is a standard macro that will rank fields within a record. The user chooses the fields he wants to Rank and the direction of the Rank (Descending or Ascending). The macro creates an additional field for each of the chosen rank fields to store the Rank value. These new fields will have the same name with a "_Rank" suffix."

You can download this from the Gallery. Here is the link: 

https://gallery.alteryx.com/#!app/RankMacro/5e12839c8a933710f08216c2

Enjoy!

-cliff

[sartkhan]

Cliff, i know it has been a long time since you shared the link, but can I still download the macro?