topic Re: Group data in one column but sort by another in Discussions

Group data in one column but sort by another

SampleIguana839 — Sat, 10 Jun 2023 23:58:42 GMT

Hi!

I have been trying to organize a set of data to group by the device column (ie all the a's are together, b's, etc), but sort them by the percent failed (ie c, F2 would be first followed by the rest of the c rows, then b, F3, and so on) similar to the picture below. When I sort by percent I get the left most table, by device I get the middle table, but I am not sure how to combine the filtering to get the right most table.

Any insights would be greatly appreciated! Thank you.

Re: Group data in one column but sort by another

jthi — Tue, 20 Dec 2022 15:19:17 GMT

Those tables seem to be from Excel, is a JMP or Excel question?

If JMP first sort by Percentage column in Descending order and then sort again by Device in descending order.

Starting point:

Sort Descending by Column3

Sort Descending by Column1

Re: Group data in one column but sort by another

SampleIguana839 — Tue, 20 Dec 2022 15:38:03 GMT

Sorry for the confusion I was using generic information in an excel table as an example. That does work, but only if the 'device' column (column 1) with the highest percentage is also at the end of the list. If a 'b' row had the percent highest value, how could you sort it then?

In this case the descending sort would bring the 'c' group to the top and not have the highest percentage shown first.

For example:

Re: Group data in one column but sort by another

hogi — Tue, 20 Dec 2022 16:18:27 GMT

Then you could "cheat" and pre-define the device order:

or add a column with the additional info:

By the way, you can also sort in a single step by first selecting both columns and then clicking on sort/descending.
The columns are used from left to right, so you have to place the main category column left of the subcategory column: