topic Invert Col Rank Functionality in Discussions

Invert Col Rank Functionality

uday_guntupalli — Mon, 08 Jan 2018 15:36:07 GMT

All,

Is there a way to invert Col Rank() functionality especially when using with a By Variable i.e. by default Col Rank() assigns 1 the lowest value in the group. However, I would like it to assign "1" the highest value similar to the Sort Argument allowing a "descending" flag.

Re: Invert Col Rank Functionality

txnelson — Mon, 08 Jan 2018 15:43:24 GMT

Here is a simple example of how to do it

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Big Class.jmp" );
New Column( "Rank Height",
	Formula(
		Col Rank( :height, <<tie( "average" ) )
	)
);
New Column( "Rank Height by age",
	Formula( col number(:height, :age)+1-Col Rank( :height, :age ) )
);

Re: Invert Col Rank Functionality

uday_guntupalli — Mon, 08 Jan 2018 15:49:39 GMT

Thanks for the quick turn around Jim.

Probably, worth requesting this a feature request for future releases.