Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
pinga01
Level I

Make contours plot horizontal with a title of different label

Here is the table and graph display with my code

Capture1.JPGCapture.JPG

 

I would like to create a report where the contour plots are horizontal by different label, as below

A                                                        B                                                              C

(contour plot of A in time order) (contour plot of B in time order) (contour plot of C in time order)

 

But the display is like:

contour plot of A (4/30)

contour plot of C (4/30)

contour plot of B (5/2)

 

I thought as a for loop it should go from A to B to C, but the graphs are displayed by time first, not horizontal, and does not have label information in the title.

How to set the title and make the graph horizontal in an order of label? Thanks.

 

My code: 

list = {"A","B","C"};
for (i=1, i <= N Items(list), i++,
obj = new window(Contour Plot(
dt << select where (:Label == list[i]) << invert row selection << exclude,
X( :X, :Y ),
Y( :VALUE ),
Show Data Points( 1 ),
Show Missing Data Points( 1 ),
Fill Areas( 1 ),
Label Contours( 0 ),
Transform( "None" ),
By (:DATA_COLLECTION_TIME),
Automatic Recalc( 0 ),
dt << select where (:Label == list[i]) << invert row selection << unexclude,
);
2 REPLIES 2
Highlighted
txnelson
Super User

Re: Make contours plot horizontal with a title of different label

I am not totally sure that this is what you want, but here are the 3 contour plots in the order you want them

contour1.PNG

Here is the script

Names Default To Here( 1 );
dt = Current Data Table();

// set the order to use for the Label column
:Label << set property( "value order", {Custom Order( {"A", "C", "B"} )} );

obj = New Window( "Example",
	hlb = H List Box(
		Contour Plot(
			X( :X, :Y ),
			Y( :VALUE ),
			Show Data Points( 1 ),
			Show Missing Data Points( 1 ),
			Fill Areas( 1 ),
			Label Contours( 0 ),
			Transform( "None" ),
			By( :Label ),
			Automatic Recalc( 0 ) 

		)
	)
);

 Or you may have wanted it

contour2.PNG

Names Default To Here( 1 );
dt = Current Data Table();

// set the order to use for the Combine column
:Combined << set property( "value order", {Custom Order(
	{"A in Time Order 04/30/2020 3:02:45 PM",
	"C in Time Order 04/30/2020 3:13:23 PM",
	"B in Time Order 05/02/2020 12:40:58 AM"}
)} );

obj = New Window( "Example",
	hlb = H List Box(
		Contour Plot(
			X( :X, :Y ),
			Y( :VALUE ),
			Show Data Points( 1 ),
			Show Missing Data Points( 1 ),
			Fill Areas( 1 ),
			Label Contours( 0 ),
			Transform( "None" ),
			By( :Combined ),
			Automatic Recalc( 0 ) 

		)
	)
);

 

Jim
Highlighted
pinga01
Level I

Re: Make contours plot horizontal with a title of different label

Not exactly. Sorry I [put the  new data table below so it will be clearer. Please check the below new table.

I actually have multiple plots for each label, and I want the plot display horizontal by label, and vertical in an order of time for each label, as this table shown.

Title of ATitle of BTitle of C
Contour plot of A on 4/30Contour plot of B on 4/30Contour plot of C on 5/2
Contour plot of A on 5/3Contour plot of B on 5/3Contour plot of C on 5/5

 

DATA_COLLECTION_TIMEVALUEXYLabel
4/30/2020 15:0291.410698-101.1159-101.116A
4/30/2020 15:0291.534599-54.724-132.115A
4/30/2020 15:0291.509598142.99980A
4/30/2020 15:0291.4627132.114954.724A
4/30/2020 15:0291.503197101.1158101.1158A
4/30/2020 15:0291.544854.724132.1149A
4/30/2020 15:0291.6363980-143A
4/30/2020 15:0291.62449654.724-132.115A
4/30/2020 15:0291.625397101.1158-101.116A
4/30/2020 15:0291.562698132.1149-54.724A
4/30/2020 15:0291.4207-550A
4/30/2020 15:0291.56199600A
4/30/2020 15:0291.436401122.5979-24.3859A
4/30/2020 15:0291.47650169.4459-103.934A
4/30/2020 15:0291.408997-24.3859-122.598A
4/30/2020 15:0291.386803-103.934-69.4459A
4/30/2020 15:0291.430702-72.83272.832A
4/30/2020 15:0291.3813020102.9998A
4/30/2020 15:0291.40740224.3859122.5979A
4/30/2020 15:0291.426498103.933769.4459A
4/30/2020 15:0291.446701-122.59824.3859A
4/30/2020 15:0291.445503-69.4459103.9337A
4/30/2020 15:0291.412804055A
4/30/2020 15:0291.451401-69.2819-40A
4/30/2020 15:0291.42820-79.9997A
4/30/2020 15:0291.456596079.9997A
4/30/2020 15:0291.493202-69.281940A
4/30/2020 15:0291.392601102.99980A
4/30/2020 15:0291.39140372.83272.832A
4/30/2020 15:0291.3700030-103A
4/30/2020 15:0291.40180272.832-72.832A
4/30/2020 15:0291.442802-102.99990A
4/30/2020 15:0291.379799-72.832-72.832A
4/30/2020 15:0291.350822.62722.627A
4/30/2020 15:0291.45649769.281940A
4/30/2020 15:0291.347099-22.627-22.627A
4/30/2020 15:0291.44190269.2819-40A
4/30/2020 15:0291.390099550A
4/30/2020 15:0291.527199-127.305973.4999A
4/30/2020 15:0291.575699-1470A
4/30/2020 15:0291.6210020146.9999A
4/30/2020 15:0291.500504-73.4999127.3059A
4/30/2020 15:0291.8827970-147A
4/30/2020 15:0291.78880373.4999-127.306A
4/30/2020 15:0291.466301-127.3059-73.4999A
4/30/2020 15:0291.621002-73.4999-127.306A
4/30/2020 15:0291.670303146.99990A
4/30/2020 15:0291.736298127.3059-73.4999A
4/30/2020 15:0291.65373.4999127.3059A
4/30/2020 15:0291.5243127.305973.4999A
4/30/2020 15:0291.4347-54.724132.1149A
4/30/2020 15:0291.4805980142.9998A
4/30/2020 15:0291.463097-132.114954.724A
4/30/2020 15:0291.4571-101.1159101.1158A
4/30/2020 15:0291.415398-132.1149-54.724A
4/30/2020 15:0291.448303-1430A
4/30/2020 15:0291.4068980-55A
5/3/2020 11:4691.22509822.62722.627A
5/3/2020 11:4691.254501-22.627-22.627A
5/3/2020 11:4691.222801550A
5/3/2020 11:4691.2570040-55A
5/3/2020 11:4691.15470100A
5/3/2020 11:4691.260201-550A
5/3/2020 11:4691.224602055A
5/3/2020 11:4691.3836980-143A
5/3/2020 11:4691.36409854.724-132.115A
5/3/2020 11:4691.188499-69.4459103.9337A
5/3/2020 11:4691.237503-122.59824.3859A
5/3/2020 11:4691.173599101.1158101.1158A
5/3/2020 11:4691.22309954.724132.1149A
5/3/2020 11:4691.294899142.99980A
5/3/2020 11:4691.173798132.114954.724A
5/3/2020 11:4691.335098101.1158-101.116A
5/3/2020 11:4691.294998132.1149-54.724A
5/3/2020 11:4691.6300960-147A
5/3/2020 11:4691.47599873.4999-127.306A
5/3/2020 11:4691.266602-127.305973.4999A
5/3/2020 11:4691.372498-1470A
5/3/2020 11:4691.227898-127.3059-73.4999A
5/3/2020 11:4691.311996-73.4999-127.306A
5/3/2020 11:4691.234001-24.3859-122.598A
5/3/2020 11:4691.193298-103.934-69.4459A
5/3/2020 11:4691.2444122.5979-24.3859A
5/3/2020 11:4691.285569.4459-103.934A
5/3/2020 11:4691.16719824.3859122.5979A
5/3/2020 11:4691.1754103.933769.4459A
5/3/2020 11:4691.309799-72.83272.832A
5/3/2020 11:4691.2937010102.9998A
5/3/2020 11:4691.265503-72.832-72.832A
5/3/2020 11:4691.274902-102.99990A
5/3/2020 11:4691.252296-54.724-132.115A
5/3/2020 11:4691.143898-101.1159-101.116A
5/3/2020 11:4691.169998-132.1149-54.724A
5/3/2020 11:4691.247398-1430A
5/3/2020 11:4691.230301-132.114954.724A
5/3/2020 11:4691.143303-101.1159101.1158A
5/3/2020 11:4691.150803-54.724132.1149A
5/3/2020 11:4691.1800990142.9998A
5/3/2020 11:4691.374173.4999127.3059A
5/3/2020 11:4691.218903127.305973.4999A
5/3/2020 11:4691.288902102.99980A
5/3/2020 11:4691.24790272.83272.832A
5/3/2020 11:4691.322098079.9997A
5/3/2020 11:4691.338501-69.281940A
5/3/2020 11:4691.3172-69.2819-40A
5/3/2020 11:4691.33110-79.9997A
5/3/2020 11:4691.32270169.2819-40A
5/3/2020 11:4691.30419969.281940A
5/3/2020 11:4691.3251040-103A
5/3/2020 11:4691.35690372.832-72.832A
5/3/2020 11:4691.446701127.3059-73.4999A
5/3/2020 11:4691.438599146.99990A
5/3/2020 11:4691.3284990146.9999A
5/3/2020 11:4691.257202-73.4999127.3059A
4/30/2020 15:1391.2610020-147B
4/30/2020 15:1390.986099-73.4999-127.306B
4/30/2020 15:1391.3069990142.9998B
4/30/2020 15:1391.02300373.4999127.3059B
4/30/2020 15:1391.216698-101.1159101.1158B
4/30/2020 15:1391.273201-54.724132.1149B
4/30/2020 15:1390.987801127.3059-73.4999B
4/30/2020 15:1391.12249873.4999-127.306B
4/30/2020 15:1390.830704127.305973.4999B
4/30/2020 15:1390.992996146.99990B
4/30/2020 15:1391.185204-132.114954.724B
4/30/2020 15:1391.193497-1430B
4/30/2020 15:1391.1959132.1149-54.724B
4/30/2020 15:1391.203201142.99980B
4/30/2020 15:1391.32849954.724-132.115B
4/30/2020 15:1391.294502101.1158-101.116B
4/30/2020 15:1391.243401-54.724-132.115B
4/30/2020 15:1391.3385010-143B
4/30/2020 15:1391.132103-132.1149-54.724B
4/30/2020 15:1391.1437-101.1159-101.116B
4/30/2020 15:1391.1884101.1158101.1158B
4/30/2020 15:1391.201897132.114954.724B
4/30/2020 15:1391.14469969.4459-103.934B
4/30/2020 15:1391.116096-24.3859-122.598B
4/30/2020 15:1391.111801103.933769.4459B
4/30/2020 15:1391.092003122.5979-24.3859B
4/30/2020 15:1391.123802-69.4459103.9337B
4/30/2020 15:1391.37560354.724132.1149B
4/30/2020 15:1391.0606-103.934-69.4459B
4/30/2020 15:1391.067802-122.59824.3859B
4/30/2020 15:1391.1027980-55B
4/30/2020 15:1391.208199-72.83272.832B
4/30/2020 15:1391.188004-102.99990B
4/30/2020 15:1391.188797-72.832-72.832B
4/30/2020 15:1391.1762010-103B
4/30/2020 15:1391.18049672.832-72.832B
4/30/2020 15:1391.169403102.99980B
4/30/2020 15:1391.19149872.83272.832B
4/30/2020 15:1391.178299079.9997B
4/30/2020 15:1391.143724.3859122.5979B
4/30/2020 15:1391.2088010102.9998B
4/30/2020 15:1391.158401-69.2819-40B
4/30/2020 15:1391.036598-22.627-22.627B
4/30/2020 15:1391.102097550B
4/30/2020 15:1391.103699055B
4/30/2020 15:1391.15630369.281940B
4/30/2020 15:1391.15290169.2819-40B
4/30/2020 15:1391.16140-79.9997B
4/30/2020 15:1391.166496-69.281940B
4/30/2020 15:1391.03980322.62722.627B
4/30/2020 15:1391.21690400B
4/30/2020 15:1391.142097-550B
4/30/2020 15:1391.0479970146.9999B
4/30/2020 15:1391.011002-1470B
4/30/2020 15:1390.909302-127.3059-73.4999B
4/30/2020 15:1390.987-73.4999127.3059B
4/30/2020 15:1390.909302-127.305973.4999B
5/3/2020 11:5891.30049973.4999-127.306B
5/3/2020 11:5891.1819127.3059-73.4999B
5/3/2020 11:5891.388496-54.724132.1149B
5/3/2020 11:5891.335503-101.1159101.1158B
5/3/2020 11:5891.294296-132.114954.724B
5/3/2020 11:5891.332397-1430B
5/3/2020 11:5891.163902146.99990B
5/3/2020 11:5890.951897127.305973.4999B
5/3/2020 11:5891.09349873.4999127.3059B
5/3/2020 11:5891.4222030142.9998B
5/3/2020 11:5891.311798-101.1159-101.116B
5/3/2020 11:5891.292397-132.1149-54.724B
5/3/2020 11:5891.5020980-143B
5/3/2020 11:5891.387299-54.724-132.115B
5/3/2020 11:5891.416298101.1158-101.116B
5/3/2020 11:5891.46910154.724-132.115B
5/3/2020 11:5891.398201142.99980B
5/3/2020 11:5891.386703132.1149-54.724B
5/3/2020 11:5891.315804101.1158101.1158B
5/3/2020 11:5891.373299132.114954.724B
5/3/2020 11:5891.37660269.281940B
5/3/2020 11:5891.252502055B
5/3/2020 11:5891.245399-550B
5/3/2020 11:5891.2738040-55B
5/3/2020 11:5891.218498550B
5/3/2020 11:5891.357002-22.627-22.627B
5/3/2020 11:5891.36560122.62722.627B
5/3/2020 11:5891.298500B
5/3/2020 11:5891.3602980-79.9997B
5/3/2020 11:5891.32959769.2819-40B
5/3/2020 11:5891.4732970-147B
5/3/2020 11:5891.177803-73.4999-127.306B
5/3/2020 11:5891.111099-127.3059-73.4999B
5/3/2020 11:5891.086899-1470B
5/3/2020 11:5890.971901-127.305973.4999B
5/3/2020 11:5891.099899-73.4999127.3059B
5/3/2020 11:5891.0835040146.9999B
5/3/2020 11:5891.334102.99980B
5/3/2020 11:5891.33360372.832-72.832B
5/3/2020 11:5891.3617020-103B
5/3/2020 11:5891.380898-72.832-72.832B
5/3/2020 11:5891.382797-69.2819-40B
5/3/2020 11:5891.3638-69.281940B
5/3/2020 11:5891.375298079.9997B
5/3/2020 11:5891.36609672.83272.832B
5/3/2020 11:5891.338402-102.99990B
5/3/2020 11:5891.336601-72.83272.832B
5/3/2020 11:5891.47509854.724132.1149B
5/3/2020 11:5891.249298-69.4459103.9337B
5/3/2020 11:5891.29879824.3859122.5979B
5/3/2020 11:5891.38060102.9998B
5/3/2020 11:5891.2332122.5979-24.3859B
5/3/2020 11:5891.242302103.933769.4459B
5/3/2020 11:5891.271202-24.3859-122.598B
5/3/2020 11:5891.28119769.4459-103.934B
5/3/2020 11:5891.202698-122.59824.3859B
5/3/2020 11:5891.209198-103.934-69.4459B
5/2/2020 0:4091.476898-132.114954.724C
5/2/2020 0:4091.533401-101.1159101.1158C
5/2/2020 0:4091.57-54.724132.1149C
5/2/2020 0:4091.6268010142.9998C
5/2/2020 0:4091.88639873.4999127.3059C
5/2/2020 0:4091.776497127.305973.4999C
5/2/2020 0:4091.712601146.99990C
5/2/2020 0:4091.550903127.3059-73.4999C
5/2/2020 0:4091.612973.4999-127.306C
5/2/2020 0:4091.5403980-147C
5/2/2020 0:4091.3174970-79.9997C
5/2/2020 0:4091.357399-69.2819-40C
5/2/2020 0:4091.376198-550C
5/2/2020 0:4091.3265055C
5/2/2020 0:4091.25900369.281940C
5/2/2020 0:4091.33630469.2819-40C
5/2/2020 0:4091.28399722.62722.627C
5/2/2020 0:4091.313698-22.627-22.627C
5/2/2020 0:4091.308098550C
5/2/2020 0:4091.3541030-55C
5/2/2020 0:4091.3337020-103C
5/2/2020 0:4091.37930372.832-72.832C
5/2/2020 0:4091.395103-102.99990C
5/2/2020 0:4091.370903-72.832-72.832C
5/2/2020 0:4091.2761079.9997C
5/2/2020 0:4091.403503-69.281940C
5/2/2020 0:4091.307701102.99980C
5/2/2020 0:4091.28630172.83272.832C
5/2/2020 0:4091.3060990102.9998C
5/2/2020 0:4091.402603-72.83272.832C
5/2/2020 0:4091.365769.4459-103.934C
5/2/2020 0:4091.64070154.724132.1149C
5/2/2020 0:4091.578796101.1158101.1158C
5/2/2020 0:4091.3405122.5979-24.3859C
5/2/2020 0:4091.33360324.3859122.5979C
5/2/2020 0:4091.339699103.933769.4459C
5/2/2020 0:4091.368103-122.59824.3859C
5/2/2020 0:4091.383698-69.4459103.9337C
5/2/2020 0:4091.286697-24.3859-122.598C
5/2/2020 0:4091.330399-103.934-69.4459C
5/2/2020 0:4091.438599-127.3059-73.4999C
5/2/2020 0:4091.259102-73.4999-127.306C
5/2/2020 0:4091.688904-127.305973.4999C
5/2/2020 0:4091.560799-1470C
5/2/2020 0:4091.9394990146.9999C
5/2/2020 0:4091.761299-73.4999127.3059C
5/2/2020 0:4091.398003101.1158-101.116C
5/2/2020 0:4091.389702132.1149-54.724C
5/2/2020 0:4091.429398142.99980C
5/2/2020 0:4091.4552132.114954.724C
5/2/2020 0:4091.257896-101.1159-101.116C
5/2/2020 0:4091.2006-54.724-132.115C
5/2/2020 0:4091.3420030-143C
5/2/2020 0:4091.352654.724-132.115C
5/2/2020 0:4091.3591-1430C
5/2/2020 0:4091.267197-132.1149-54.724C
5/2/2020 0:4091.38410200C
5/5/2020 5:5091.305099-69.2819-40C
5/5/2020 5:5091.291-69.281940C
5/5/2020 5:5091.199501079.9997C
5/5/2020 5:5091.15650272.83272.832C
5/5/2020 5:5091.212997055C
5/5/2020 5:5091.17079969.281940C
5/5/2020 5:5091.23449769.2819-40C
5/5/2020 5:5091.2587970-79.9997C
5/5/2020 5:5091.196297102.99980C
5/5/2020 5:5091.26010172.832-72.832C
5/5/2020 5:5091.76909673.4999127.3059C
5/5/2020 5:5091.4718020142.9998C
5/5/2020 5:5091.457901-132.114954.724C
5/5/2020 5:5091.458-1430C
5/5/2020 5:5091.435402-54.724132.1149C
5/5/2020 5:5091.458199-101.1159101.1158C
5/5/2020 5:5091.217499-54.724-132.115C
5/5/2020 5:5091.3246990-143C
5/5/2020 5:5091.375999-132.1149-54.724C
5/5/2020 5:5091.276901-101.1159-101.116C
5/5/2020 5:5091.297997-550C
5/5/2020 5:5091.2272030-55C
5/5/2020 5:5091.23169722.62722.627C
5/5/2020 5:5091.203300C
5/5/2020 5:5091.185204550C
5/5/2020 5:5091.279602-22.627-22.627C
5/5/2020 5:5091.185204-69.4459103.9337C
5/5/2020 5:5091.49320254.724132.1149C
5/5/2020 5:5091.211502-103.934-69.4459C
5/5/2020 5:5091.231499-122.59824.3859C
5/5/2020 5:5091.402199142.99980C
5/5/2020 5:5091.356102132.1149-54.724C
5/5/2020 5:5091.411797101.1158101.1158C
5/5/2020 5:5091.3862132.114954.724C
5/5/2020 5:5091.299301101.1158-101.116C
5/5/2020 5:5091.29229754.724-132.115C
5/5/2020 5:5091.7785030146.9999C
5/5/2020 5:5091.184402122.5979-24.3859C
5/5/2020 5:5091.103203103.933769.4459C
5/5/2020 5:5091.15160424.3859122.5979C
5/5/2020 5:5091.2668-72.83272.832C
5/5/2020 5:5091.301598-102.99990C
5/5/2020 5:5091.261902-72.832-72.832C
5/5/2020 5:5091.2501980-103C
5/5/2020 5:5091.167198-24.3859-122.598C
5/5/2020 5:5091.23200269.4459-103.934C
5/5/2020 5:5091.1938020102.9998C
5/5/2020 5:5091.695297-127.305973.4999C
5/5/2020 5:5091.755096-73.4999127.3059C
5/5/2020 5:5091.684601127.305973.4999C
5/5/2020 5:5091.6297146.99990C
5/5/2020 5:5091.532501127.3059-73.4999C
5/5/2020 5:5091.48650473.4999-127.306C
5/5/2020 5:5091.5642010-147C
5/5/2020 5:5091.348801-73.4999-127.306C
5/5/2020 5:5091.486702-127.3059-73.4999C
5/5/2020 5:5091.751404-1470C
Article Labels