topic Re: How to organize data table based on total count (categorical data)? in Discussions

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

ConditionalAvg2 — Sat, 10 Jun 2023 23:53:52 GMT

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!

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

txnelson — Mon, 05 Sep 2022 04:47:37 GMT

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.

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

ConditionalAvg2 — Mon, 05 Sep 2022 05:23:13 GMT

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

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

ConditionalAvg2 — Tue, 06 Sep 2022 02:44:48 GMT

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!

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

txnelson — Tue, 06 Sep 2022 03:54:17 GMT

Is this what you are looking for

If so, then stack your data table

And run the Fit y by x