cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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