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!

[#2 · Accepted solution]

All you have to do is to Stack the table

     Tables=>Stack

The resulting table looks like 

Then open Graph Builder and you can produce the following graph

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

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) :

Thank you!

[#5]

Is this what you are looking for

If so, then stack your data table

And run the Fit y by x