cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Add dense ranking to Ranking Tie and Col Rank functions

This would help for example when making numeric encoding for character values. Dense Rank (wikipedia) or calculating orders

For example scipy.stats.rankdata offers average, min, max, dense and ordinal

6 Comments
Status changed to: Acknowledged
 
mia_stephens
Staff
Status changed to: Investigating
 
hogi
Level XII

very low hanging fruit

some minutes of programming  -> many happy users

hogi
Level XII

@mia_stephens 

Besides a setting for JSL, Dense ranking should also be added to  new formula column.

 

To keep the menu slim:

 

the current status or a modifier key (CTRL or Shift) could be used to control  dense ranking yes/no

hogi
Level XII

Related wish

Col N Categories 

miguello
Level VI

I concur...

 

Just asked about how to implement this functionality here:
https://community.jmp.com/t5/Discussions/How-to-tweak-Col-Rank-to-give-consecutive-numbers-when-usin...

 

This is something that I encounter quite often and each time I have to write a small script\big formula for that.