cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Due to global connectivity issues impacting AWS Services, users may experience unexpected errors while attempting to authorize JMP. Please try again later or contact support@jmp.com to be notified once all issues are resolved.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles