767776_en-US

liliconcom

Tabulate - N categories ?

Tabulate and Tables/Summary are very similar, but ...
hey, Tabulate, what is the difference between counting numerical and non-numerical categories?

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Summary(
	Group( :age ),
	N Categories( :sex )
);

dt << Tabulate(
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Analysis Columns( :sex ), Statistics( N Categories ) ),
		Row Table( Grouping Columns( :age ) )
	)
);

Tables/Summary:

 

Tabulate: 

same settings, but Tabulate will fail and generate a warning:

Data Exploration and VisualizationRe: Tabulate - N categories ?

dirty workaround: 

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Tabulate(
	Transform Column(
		"sex_num",
		Formula( Col Rank( :sex, <<TIE></TIE>

Re: Tabulate - N categories ?

fun fact:
for header statistics, N unique (= N categories)  is available for categorical entries:

 

... but not for continuous ones:

 

Re: Tabulate - N categories ?

Good point @hogi ! Why don't the N categories work in the Tabulate platform? Do you know if it exist a Wish List item to get this implemented?

Re: Tabulate - N categories ?

According to my records, there is no entry in the wish list.

happy news:
With JMP19, it's now MUCH easier to use the workaround with the dense rank:
 Col Score()
New in Graph Builder for JMP 19 

 

Tabulate(
	Transform Column( "Score Unique[sex]", Formula( Col Score( :sex ) ) ),
	Add Table(
		Column Table( Statistics( N Categories ), Analysis Columns( :sex) ),
		Column Table( Statistics( N Categories ), Analysis Columns( :"Score Unique[sex]"n ) ),
		Row Table( Grouping Columns( :age ) )
	)
);