cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

Table Summary Menu - N non-zero

☐ cool new feature
☐ could help many users!

☐ removes a „bug“

☑ nice to have

☐ nobody needs it

For the Tabel Summary menu, please add

 

N non-Zero
https://community.jmp.com/t5/Discussions/Table-summary-quot-N-non-zero-quot/m-p/577884#M78540

to count the non-empty, non-zero values


application cases:
- how many countries had > = 1  covid cases in the month/year xx/yyyy.
- how many  wafers had >= 1 defects

3 Comments
Status changed to: Acknowledged

Hi @hogi, thank you for your suggestion! We have captured your request and will take it under consideration.

hogi
Level XI

As it's possible to interactively add Formulas by right clicking in the summary menu, the user can easily create such a query on his own.

@Sarah-Sylvestre : For me it's OK if you archive this wish.

hogi_0-1671562276819.png

 

Status changed to: Archived

Thank you! I will archive this.