cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

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