topic Re: Tabulate - N categories ? in Discussions

Tabulate - N categories ?

hogi — Mon, 24 Jun 2024 07:44:30 GMT

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:

Re: Tabulate - N categories ?

hogi — Mon, 24 Jun 2024 07:52:39 GMT

dirty workaround:

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Tabulate(
	Transform Column(
		"sex_num",
		Formula( Col Rank( :sex, <<tie( minimum ) ) )
	),
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Statistics( N Categories ), Analysis Columns( :sex_num ) ),
		Row Table( Grouping Columns( :age ) )
	)
);

Re: Tabulate - N categories ?

hogi — Mon, 24 Jun 2024 09:39:07 GMT

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

... but not for continuous ones:

Re: Tabulate - N categories ?

Steffen_Bugge — Tue, 23 Sep 2025 07:43:09 GMT

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 ?

hogi — Tue, 23 Sep 2025 07:53:43 GMT

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()

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 ) )
	)
);