How to organize data table based on total count (categorical data)?

[#1]

Hi,

Below are a sample of raw data that I have which is labelled by 1 if the root cause is applicable to the respective pump failure. However, how can I effectively sort these data based on the total count in JMP data table as shown in the 2nd table so that I am able to plot the final graph attach?

Note: In reality, I have more than 1000 rows and 30 columns. Therefore, I'm trying to find the most effective way to organize this. 

Thank you!

ConditionalAvg2_0-1662342442288.png

[#2 · Accepted solution]

All you have to do is to Stack the table

     Tables=>Stack

txnelson_0-1662352551538.png

The resulting table looks like 

txnelson_1-1662352599214.png

Then open Graph Builder and you can produce the following graph

txnelson_0-1662353083145.png

Here is the table with the Control Panel open so you can see what interactive steps were used to produce the graph

txnelson_1-1662353141984.png

I also set the Value Ordering column property for the Failure Type column to get the order to be the same as what you showed in the example graph.  I also clicked on the Legend items to change the colors to match your example.

[#3]

That worked exactly like how I wanted it, thank you! :)

[#4]

Hi Jim, 

I have an additional question if you don't mind. I have another column that has the total number of equipment failure by pump no., is there a way that I can find out the failure rate for each pump based on each failure type? Tried using fit Y by X to obtain the contingency however it didn't come up the way I wanted to. 

Pump No.	Total No of Failure	Seal Leakage	Bearing Issues	Impeller Wear	Cavitation
A	5	1	1	1	2
B	4	1	1	1	1
C	2	0	0	2	0
D	3	1	0	0	2

I am aiming for something like this (taken from another discussion) :

ConditionalAvg2_0-1662432211516.png

Thank you!

[#5]

Is this what you are looking for

txnelson_0-1662436317888.png

If so, then stack your data table

txnelson_1-1662436394754.png

And run the Fit y by x

txnelson_2-1662436450454.png