- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Histogram sorting
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Histogram sorting
Sorting has to be based on something. What would be the "correct" sorting for these for example?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Histogram sorting
I would like to base on HOT stress
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Histogram sorting
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")