Using Hex values for the Y-Axis Labels

Question

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?

jmp_question_hex_values.png

hogi · Answer

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 ) ) )
);

hogi · Answer

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

steidley · Answer

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