cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Nath
Level I

How to order my values including supercategories created?

Hello, I have created supercategories but can't order my values including my supercategories in a specific order (ex: supercategory Top2Boxes, then supercategory TopBox, then each of my value in descending order 'strongly agree' etc.). How can I do this please? Many thanks and kind regards, 

4 REPLIES 4
hogi
Level XIII

Re: How to order my values including supercategories created?

order the rows in the data table?
Place the columns from left to right, select them and click on Tables/Sort.

With the arrows you can choose ascending and descending order:

hogi_0-1758257577491.png

 

 

order in Graph Builder?
a) after sorting the entries in the data table, create a new row with formula row(). Then use this column for sorting.

 

b) use nested categories on the Axis:

hogi_1-1758257213144.png



Nath
Level I

Re: How to order my values including supercategories created?

thank you! and what about ordering the rows (and my created supercategories) of my categorical table (from 'consumer research' platform)? i guess it is under column info > value order and supercategories, but can't seem to include my supercategories in my value order

many thanks and kind regards,

Nath_0-1758267061820.png

Nath_1-1758267105395.png

 

hogi
Level XIII

Re: How to order my values including supercategories created?

Ah, sorry, I didn't know about this feature.

The Supercategories don't seeem to be disjoint - and there is no "order", right?
So difficult to use this information for ordering.

I hope another user has more experience with supercategories and can help or comment ...

Nath
Level I

Re: How to order my values including supercategories created?

thats all good thanks a lot  again!

Recommended Articles