In the Table summary menu ...
- N counts all non-Missing entries (including 0s)
- N Missing counts all missing values
- Sum sums the values,
which acts like ~ N non-Zero, if values are just 0 and 1
But I miss an entry
- N non-Zero (which works in general ,not just for 0/1 values)
There are many applications for such an aggregation, like:
- which cities had >=1 covid cases in the month/year xx/yyyy.
- which wafers had >=1 defects.
It's clear that one can add aditional columns to the data table, set non-zero values to 1, and use sum as a workaround for N non-Zero,
but is there a way to get it directly via Table Summary?
![hogi_0-1670324922867.png hogi_0-1670324922867.png](https://community.jmp.com/t5/image/serverpage/image-id/47957i758886C63DD6E3A4/image-size/medium?v=v2&px=400)