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 Screenshot 2023-04-10 101546.png](https://community.jmp.com/t5/image/serverpage/image-id/51871iCF5843A9AFFB94B3/image-size/large?v=v2&px=999)
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