cancel
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
Jacobusk
Level I

Using tabulate Row % within a group

Hello everyone, 

 

I am using tabulate to massage data to exemplify yields and failures of machines. Generally the data is sorted by date (as Rows), and status (columns). 

 

I wanted to group this info by machines, as shown below.

 

Screenshot 2023-04-10 101546.png

A - accept ; R - reject

 

I would like to display this as percentages. i.e. yield of the machine per day. The Row % on tabulate is usually what I would use. In this case, it will find the percent's across the entire group, not by machine, which is less helpful. If there a function that can convert these to percentages by machine? i.e. machine one would have - 50%, 50%, 83%, 60% etc..... 

 

Or will I need to script a new column in that calculates yield for each?

 

This is using JMP 14

 

Thank you 

1 REPLY 1
jthi
Super User

Re: Using tabulate Row % within a group

You could try moving your machine (or status) to be row identifier rather than column

jthi_0-1681189295254.png

and then try using Row% (or Column %)

jthi_1-1681189302539.png

 

Creating formula column should also be fairly simple with Col Sum() and Col Number(). You could also use Summary table and then perform calculation there

-Jarmo

Recommended Articles