cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Dennisbur
Level IV

Histogram sorting

Hello guys

I have created a histogram per 2 subgroups VMAX and VMIN

I tried to sort each group from the right (height value) to the left (less value), but I see it is not in 100% correct

for example, MIPI Re has 85% and should be after MIPI Rx.

Can you recommend what I need to do for the right sorting?

 

Dennisbur_1-1712577472134.png

 

 

7 REPLIES 7
jthi
Super User

Re: Histogram sorting

One option is to create new column which combines your groups and then use that as X-Axis.

Start situation without new column

jthi_2-1712580093846.png

with new column (you could clean the values for example by using Value Labels or adding more columns and hiding the new column)

jthi_3-1712580101069.png

Labels cleaned

jthi_5-1712580335439.png

 

 

 

-Jarmo
Dennisbur
Level IV

Re: Histogram sorting

Hello, 

It does not really assist when I delete VMIN or VMAX in the demo column (bucket + voltage_corner) by recode 

the graph builder re-sort the percentage like before

Please, do you know any other solution?

jthi
Super User

Re: Histogram sorting

This is our starting situation

jthi_7-1712585069795.png

 

jthi_0-1712584851092.png

We create new column which concatenates bucket and corner

jthi_1-1712584880761.png

We then build X-axis such as way that corner is on lowest level, middle our new column and highest bcket

jthi_2-1712584966679.png

Then we double click on x-axis hide our new column

jthi_4-1712584998866.png

right click and order by desc

jthi_5-1712585022235.png

jthi_6-1712585032737.png

Depending on your data you might have to modify your order statistic.

 

Or do you wish to have something else as your final layout?

-Jarmo
Dennisbur
Level IV

Re: Histogram sorting

Hello

Yes, at the end, I should add additional sort by HOT and COLD

and I see when I added it, the sorting broke down...

 

Dennisbur_0-1712599386184.png

 

jthi
Super User

Re: Histogram sorting

Sorting has to be based on something. What would be the "correct" sorting for these for example?

jthi_0-1712600662380.png

 

-Jarmo
Dennisbur
Level IV

Re: Histogram sorting

I would like to base on HOT stress

jthi
Super User

Re: Histogram sorting

You can fairly freely create ordering/ranking column to data table and use that for additional sorting

jthi_0-1712657071673.png

Col Rank(If(:temp == "hot", :perc, .), :corner) + (:corner == "vmin")
-Jarmo