topic Re: Using Hex values for the Y-Axis Labels in Discussions

Using Hex values for the Y-Axis Labels

steidley — Fri, 02 May 2025 15:08:37 GMT

In JMP 18,

I have a set of data grouped by category. The X-Axis holds the category (character) and the Y-Axis is the value in hexadecimal.

I have three columns of the data:

1) original value as hex

- character nominal

- :mv

- eg. 0x066F

2) :mv converted to a decimal number

- continuous number format

- :mv_number

- eg 1647

3) :mv_number converted back to hex, but without the 0x

- character - nominal

- :mv_hex_label

- eg 066F

Is there a way to graph this data so that the labels for the tick marks on the Y-Axis are in Hex, and in numerical order as opposed to alphabetical order?

Re: Using Hex values for the Y-Axis Labels

jthi — Fri, 02 May 2025 15:20:35 GMT

Take a look at Value Labels column property

Re: Using Hex values for the Y-Axis Labels

txnelson — Fri, 02 May 2025 16:31:44 GMT

You could also look at displaying the Hex values and then using Value Ordering column property to set the order in the graph.

Re: Using Hex values for the Y-Axis Labels

hogi — Fri, 02 May 2025 19:17:40 GMT

as a third option, use the hex labels, and in addition drag the numeric column into this drop zone - to use it for ordering.
The same can be done via right click / order by / Others ...

just takes a few seconds - independent of the number of entries.

Re: Using Hex values for the Y-Axis Labels

steidley — Fri, 02 May 2025 19:47:00 GMT

Reading all three suggestions got me in the ballpark for an answer. Thank you!

What I ultimately have done is to set up the Y axis with the original data column 'mv'. I then drug the decimal version of the data next to the Y axis and dropped it in the "Order By" section:

This did in fact order the values correctly.

Now, my only lament is that I have lost the sense of scale. Values like 03DB are right next to 0668. This has lost a lot of the intuition about data points that exhibit bi-modeality.

Here, you can see that data passes in one region and fails in other regions:

Since exact hex values are not critical, I think what I will do is explore creating reference lines to let me know where 0x100, 0x800, 0xF00 are...

Re: Using Hex values for the Y-Axis Labels

hogi — Sat, 03 May 2025 15:19:06 GMT

Happy to see that you like the "order by" functionality.:)

Re: Using Hex values for the Y-Axis Labels

hogi — Sat, 03 May 2025 15:30:40 GMT

To add some structure, you can use nested levels on the Y axis:

dt = New Table( "Hex",
	Add Rows( 20 ),
	New Column( "Hex",
		Character,
		Set Values(
			{"0x0EB6", "0x00E0", "0x0052", "0x0059", "0x0052", "0x0037", "0x002E",
			"0x0025", "0x0C74", "0x0C6B", "0x0C5E", "0x0C55", "0x0C2E", "0x0C19",
			"0x0BE7", "0x0B9A", "0x0B8E", "0x0B53", "0x0B30", "0x00B5"}
		)
	),
	New Column( "Hex Group", Character, "Nominal", Formula( Substr( :Hex, 1, 4 ) ) ),
	New Column( "decimal",
		Formula( Hex To Number( Substr( :Hex, 3 ) ) )
	)
);

dt << Graph Builder(
	Variables(
		X( :decimal ),
		Y( :Hex Group, Order By( :decimal, Ascending) ),
		Y( :Hex, Position( 1 ), Order By( :decimal, Ascending ) ),
		Color( :Hex Group )
	),
	Elements( Bar( X, Y( 1 ), Y( 2 ) ) )
);