Using tabulate Row % within a group

Jacobusk — Sun, 11 Jun 2023 00:00:22 GMT

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

Re: Using tabulate Row % within a group

jthi — Tue, 11 Apr 2023 05:04:59 GMT

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

topic Re: Using tabulate Row % within a group in Discussions

Using tabulate Row % within a group

Re: Using tabulate Row % within a group