Getting mode statistics in tabulateHi JMP user community,
I have periodic inprocess record for batches manufactured, monitoring frequency is every 15 mins.
I have to calculate batch specific mode for the respective in-process entry.
I can't see the option of mode statistics in Analyze > tabulate. I am using JMP 14.3.0.
Is there way to get Mode as statistics using tabulate.
Thanks!

OtherRe: Getting mode statistics in tabulateThanks for the script!
This is helpful..Re: Getting mode statistics in tabulateMode is not available in Tabulate, however it is available in Distribution, and with a little JSL, it can be added to your Tabulate table. All it takes is to precalculate the MODE and then add it as a new column into your data table.

The missing values are because for those heights, multiple mode values were found.
Here is the JSL
names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");
dis = dt << Distribution(invisible,
Continuous Distribution(
Column( :height ),
Customize Summary Statistics( Mode( 1 ) )
),by(:age)
);
dtstats = report(dis[1])["Summary Statistics"][TableBox(1)]<<MAKE combined="" data="https://community.jmp.com/" table=""></MAKE>