For the Tabel Summary menu, please add the following settings:
- N non-Zero
https://community.jmp.com/t5/Discussions/Table-summary-quot-N-non-zero-quot/m-p/577884#M78540
application cases:
- how many countries had > = 1 covid cases in the month/year xx/yyyy.
- how many wafers had >= 1 defects. - Median
Quantile(0.5, column name)
is available as a workaround, but it's very inconvenient that the syntax differs from all the other settings.
Instead of
aggregation(col)
one always has to distinguish:
aggregationExpr = Match( aggregation ,
"Median", Expr( Quantiles( 0.5 ) ),
"Max", Expr( Max() ),
"Mean", Expr( Mean() ),
"min", Expr( Min() )
);
Insert Into( aggregationExpr, col ) );
