590079_en-US

liliconcom

Re: Add dense ranking to Ranking Tie and Col Rank functions - Status changed to: InvestigatingRe: Add dense ranking to Ranking Tie and Col Rank functions - Status changed to: AcknowledgedRe: Add dense ranking to Ranking Tie and Col Rank functions

very low hanging fruit

some minutes of programming  -> many happy users

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

Automation and ScriptingRe: Add dense ranking to Ranking Tie and Col Rank functions

@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

Re: Add dense ranking to Ranking Tie and Col Rank functions

Related wish

Col N Categories 

Re: Add dense ranking to Ranking Tie and Col Rank functions

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-using/m-p/782021

 

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

Re: Add dense ranking to Ranking Tie and Col Rank functions - Status changed to: AcknowledgedRe: Add dense ranking to Ranking Tie and Col Rank functions

many thanks

Re: Add dense ranking to Ranking Tie and Col Rank functions

.

Re: Add dense ranking to Ranking Tie and Col Rank functions

@Sarah-Sylvestre , maybe add a reverse version as well [via the right click new formula column menu] ?
How to filter to show last n items/values? 

For standard Rank, there is such an option:

 

Similar benefit for Dense Ranking [= Col Score()].

 

Re: Add dense ranking to Ranking Tie and Col Rank functions - Status changed to: Yes, Stay Tuned!

This functionality will be available in JMP 19.

Re: Add dense ranking to Ranking Tie and Col Rank functions - Status changed to: Delivered