topic Re: Temperature Profile - visualization in Discussions

Temperature Profile - visualization

Mila — Mon, 05 Aug 2019 21:37:01 GMT

Hi Guys,

Could you please advice, how I can create below graph:

I have been looking into graph builder but no luck.

Thank you in advance

Temperature PROFILE

Re: Temperature Profile - visualization

Craige_Hales — Tue, 06 Aug 2019 02:39:28 GMT

If you have the existing graph in JMP, use the red triangle menu and either redo->relaunch->OK to see the interactive builder, or save script to script window to get a script to reproduce it.

In Graph Builder, starting from scratch, drag variables to the drop zones and pick the heat map style (and turn off the other styles if dots are showing up.)

Graph Builder

this script builds a test table and runs a graph builder script. Using ordinal for pen and date makes the axes behave the way you expect.

dt = New Table( "Untitled 2",
	Add Rows( 0 ),
	New Column( "date", Numeric, "ordinal", Format( "y/m/d", 12 ) ),
	New Column( "pen", Numeric, "ordinal", Format( "Best", 12 ) ),
	New Column( "location", Character, "Nominal" ),
	New Column( "temp", Numeric, "Continuous", Format( "Best", 12 ) )
);
For( t = Today(), t <= Today() + In Days( 10 ), t += In Days( 1 ),
	For( p = 1, p <= 20, p += 2,
		For( io = 0, io <= 1, io += 1,
			dt << addrows( 1 );
			dt:date = t;
			dt:pen = p;
			dt:location = If( io, "inside", "outside" );
			dt:temp = p + 10 * io + Random Integer( 0, 9 );
		)
	)
);

dt << Graph Builder(
	Size( 476, 580 ),
	Show Control Panel( 0 ),
	Variables( X( :date ), Y( :pen ), Group Y( :location ), Color( :temp ) ),
	Elements( Heatmap( X, Y, Legend( 42 ) ) )
);

Heat map

Re: Temperature Profile - visualization

Mila — Tue, 06 Aug 2019 11:29:45 GMT

Thank you very much for helping me out.

I struggle with pen numbers: my data loggers were allocated outside of pens : 1,4,6,8,10,11,13,15,17 and 20.

Could you please let me know how to present only this pens on Y axis.

I have been trying to do this in axis settings but no luck..

Re: Temperature Profile - visualization

Craige_Hales — Tue, 06 Aug 2019 15:06:10 GMT

try making pen (and probably date as well) ordinal.

click the icon to change the modeling type

After deleting pens 3 and 5 I get this axis

3 and 5 are gone

I think you are still using the continuous modeling type.