User Community
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: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 4:55 PM (1043 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 (1034 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

Recommended Articles