cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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