topic Re: Sorting data table by row color in Discussions

Sorting data table by row color

QualEng79 — Tue, 16 Jul 2019 19:10:16 GMT

Hello JMP users

I am relatively new to JMP and i believe what i have attempted today should have been done in excel but alas. I am currently analyzing complaint data in JMP, and I have labeled my data table rows by color based on certain criteria (specific content i was looking for in a complaint description). I have three different colors.

Now i realize there is no easy way to filter, sort, or tabulate simply based on row color. Seems unnecessarily complex - but again i should have done this in excel. I realize in order to sort this way i probably need to create a column with a formula which converts the row color data to another type of data. Im not clear on how to do this. Anyone have an example of such formula? Basically what i would want to do is perhaps conver the color i selected (ie red) to "Yes" , or something similar. Thank you

Re: Sorting data table by row color

txnelson — Tue, 16 Jul 2019 20:02:08 GMT

If you use this formula in a new column, it will return the JMP color number for the row. from there you can set your values.

Color Of( Row State( Row() ) )

Depending on the colors you chose, it may provide a pretty big negative number......but you just have to know what the numbers are, and then use it appropriately

If(Color Of( Row State( Row() ) ) == -13912408, "Good",
color Of( Row State( Row() ) ) == -4042310, "OK",
"Bad")

You can also just create a new column with the Modeling Type of "RowState". Then in the columns panel on the left of the data table, you can right click on the red star next to the new RowState column you created, and select " Copy from RowStates". You will then have a column you can sort, etc.

Re: Sorting data table by row color

QualEng79 — Tue, 16 Jul 2019 20:17:35 GMT

that worked, thank you so much, you saved me a lot of pain! @txnelson