再次密集排序

[#1]

回到这个话题：

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

我再次需要类似的东西，但这次我无法对表格进行排序。

所以我使用公式：

Col Rank( Round( :Column ), :Category, <

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?




[#2]

如果不需要公式，通常可以使用汇总表来计算排名，然后可以使用更新将它们添加回原始表。

[#3]

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

...你只需要等待列顺序()又名col score()：

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