cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
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