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: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

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 (1769 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 (1760 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