topic Histogram sorting in Discussions

Histogram sorting

Dennisbur — Mon, 08 Apr 2024 11:58:09 GMT

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?

jthi — Mon, 08 Apr 2024 12:46:48 GMT

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

Start situation without new column

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

Labels cleaned

Dennisbur — Mon, 08 Apr 2024 13:38:36 GMT

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 — Mon, 08 Apr 2024 14:08:51 GMT

This is our starting situation

We create new column which concatenates bucket and corner

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

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

right click and order by desc

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

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

Dennisbur — Mon, 08 Apr 2024 18:06:18 GMT

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...

jthi — Mon, 08 Apr 2024 18:25:19 GMT

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

Dennisbur — Tue, 09 Apr 2024 08:31:40 GMT

I would like to base on HOT stress

jthi — Tue, 09 Apr 2024 10:05:47 GMT

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

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