- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Dense Col Rank again
Going back to this topic:
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?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Dense Col Rank again
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.
-Jarmo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Dense Col Rank again
... you just have to wait for col order() aka col score():