cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

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

ConditionalAvg2
Level I

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

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

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.

 

Jim

View solution in original post

4 REPLIES 4
txnelson
Super User

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

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.

 

Jim


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

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


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

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 FailureSeal LeakageBearing IssuesImpeller WearCavitation
A51112
B41111
C20020
D31002

 

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

ConditionalAvg2_0-1662432211516.png

Thank you!

txnelson
Super User


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

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

 

Jim