577877_en-US

liliconcom

Re: Table summary: "N non-zero" ?

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.

Re: Table summary: "N non-zero" ?

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

 

Re: Table summary: "N non-zero" ?

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

looks like I got trapped in some weird belief.

 

 

Re: Table summary: "N non-zero" ?

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:

Table summary: "N non-zero" ?

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?

 

AnalyticsData Table