846993_it-IT

liliconcom

Di nuovo Dense Col Rank

Tornando a questo argomento:

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

Mi serve di nuovo qualcosa di simile, ma questa volta non riesco a ordinare la tabella.

Quindi utilizzo la formula:

Col Rank( Round( :Column ), :Category, <<TIE></TIE>

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?

<A href="https://community.jmp.com/t5/user/viewprofilepage/user-id/14366" target="_blank">@jthi</A> - any suggestions?

<BR /><LINGO-LABS id="lingo-labs-846993" slang="en-US" mode="CREATE"><LINGO-LABEL>Automazione e scripting</LINGO-LABEL></LINGO-LABS>Re: Ancora Dense Col Rank

Se non hai bisogno di una formula, solitamente puoi usare la tabella Riepilogo per calcolare le classifiche e poi usare Aggiorna per aggiungerle nuovamente alla tabella originale.

Re: Ancora Dense Col Rank

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

... devi solo attendere ordine col() ovvero punteggio col():

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