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.
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
You could try moving your machine (or status) to be row identifier rather than column
and then try using Row% (or Column %)
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