cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
padhikari
Level I

Percentage for each row

Hello,

 

I am trying to find the percentage of fail for each membrane lot base on the count of fail to pass for each number of rows for the specific membrane lot number. 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Percentage for each row

Create a new data table using

     Tables==>Split

Selecting ODStatus   as the Split variable and

Selecting N Rows as the Split Columns

You should also Select MembraneLot of Just ........ as the Group column

In the new data table you will now have a Fail and a Pass column, which you can then create a New column and using a formula of

     :Pass/(:Pass+:Fail)

to create your % value

Jim

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: Percentage for each row

Create a new data table using

     Tables==>Split

Selecting ODStatus   as the Split variable and

Selecting N Rows as the Split Columns

You should also Select MembraneLot of Just ........ as the Group column

In the new data table you will now have a Fail and a Pass column, which you can then create a New column and using a formula of

     :Pass/(:Pass+:Fail)

to create your % value

Jim
KarenC
Super User (Alumni)

Re: Percentage for each row

Two other options:

 

1. Tabulate: drag lot to the rows zone, status to the column zone, N to the Freq, and Row % to the cells.

2. Analyze > Consumer Research > Categorical then Responses = OD Status, X,Grouping = Lot, and Freq = N.

padhikari
Level I

Re: Percentage for each row

Thank you so much for your help. It worked great!