This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
stevend1219
stevend1219
Level II

know number of data-missing row when making a summary table

Created: Oct 22, 2022 07:19 AM  |  Last Modified: Jun 10, 2023 07:55 PM (248 views)

Hi all JMP experts,

 

I'm making a summary table from a raw data table - taking median by group names defined in column "purpose," e.g. a group is named "BSL."

The summary table shows that there are totally 744 rows of group "BSL" that are used for summary-extraction, but is there a way to know within the 744 data rows, how many rows contain/doesn't contain(i.e. missing) numbers?

 

 

stevend1219_0-1666436927406.png

 

0 Kudos
1 REPLY 1
txnelson
Super User txnelson
Super User

Re: know number of data-missing row when making a summary table

Oct 22, 2022 08:22 AM (239 views)  |  Posted in reply to message from stevend1219 10-22-2022

One of the statistics available in

     Tables=>Summary

is    N Missing

It will provide the number of missing rows within each group

txnelson_0-1666441339129.png

 

Jim