Table summary: "N non-zero" ?

[#1]

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?

[#2]

I think most of the available summary statistics are mentioned here Using JMP > Summarize Your Data > Explanation of Summary Statistics and there is none for N Zero/N Non-Zero. Plenty of workarounds though as you said. There are most likely quite a few others which would be nice to have in Summary table (and in many other platforms, such as Tabulate and Graph Builder's Summary statistic).

Edit:

I work quite often with new (to me) data tables and that is why I wrote this add-in Analyse Columns . It has quite many different summary statistics but it's purpose isn't really same as Summary tables.

[#3]

Thanks for the feedback. Hm ...

edit: everything fine with median

Another thing which I really miss a lot in Table Summary:

Median

Sure, there is Quantiles - but with an additional Median, things would be a bit easier:

[#4]

Summary does have Median (but it isn't close to Mean so it is fairly easy to miss)

[#5]

Ah, right - there is definitely a median -- also on my system :)

looks like I got trapped in some weird belief.