topic Re: Dense Col Rank again in Discussions

Dense Col Rank again

miguello — Mon, 10 Mar 2025 17:52:03 GMT

Going back to this topic:

https://community.jmp.com/t5/Discussions/How-to-tweak-Col-Rank-to-give-consecutive-numbers-when-using/m-p/782021

I need something similar again, but this time I cannot sort table.

So I use formula:

Col Rank( Round( :Column ), :Category, <<tie( "minimum" ) )

It gives me column filled with the following values: {1, 114, 340, 453, 1018, 1131, 1357}

I need to turn them into {1, 2, 3...} and so on.

One idea is to construct Associate Array where a key would be a position of the number, and the value would the same number, and then use it create a column I need. Any other suggestions?

@jthi - any suggestions?

Re: Dense Col Rank again

jthi — Mon, 10 Mar 2025 18:07:01 GMT

If you don't need a formula, Summary table can usually be used to calculate the ranks and then you can use Update to add them back to your original table.

Re: Dense Col Rank again

hogi — Mon, 10 Mar 2025 21:24:46 GMT

https://community.jmp.com/t5/Discussions/How-to-tweak-Col-Rank-to-give-consecutive-numbers-when-using/m-p/782377/highlight/true#M96575

... you just have to wait for col order() aka col score():

https://community.jmp.com/t5/JMP-Wish-List/Group-by-sooo-useful-how-about-Interpolate/idc-p/828742/highlight/true#M6900