cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-779671%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EGraph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779671%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20big%20data%20table%20and%26nbsp%3B%20a%20script%20to%20plot%20the%20subset%20by%20product.%20You%20can%20see%20the%20%22where%22%20in%20the%20script%20below.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20keep%20the%20x-axis%20to%20be%20the%20same%20from%20product%20to%20product.%20The%20x-axis%20has%20two%20variables%20%22PROC%22%20and%20%22CoreVoltage%22.%26nbsp%3B%20%26nbsp%3B%20As%20you%20can%20see%20from%20the%20jpg%20file%2C%20at%20one%20%22PROC%22%2C%20only%20some%20of%20the%20%22CoreVoltage%22%20showed%20up.%20How%20to%20show%20all%20the%20%22PROC%22%20and%20%22CoreVoltage%22%20combinations%20so%20from%20product%20to%20product%20the%20plots%20keep%20the%20same%20x-axis%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Current%20Data%20Table()%3B%0ASummarize(%20dt%2C%20prodval%20%3D%20By(%20%3A%22prod%22%20)%2C%20)%3B%0An%20%3D%20N%20Items(%20prodval%20)%3B%0A%09%0AFor(i%20%3D%201%2Ci%26lt%3B%3Dn%2Ci%20%2B%2B%2C%09%0A%09Graph%20Builder(%0A%09%09Size(%201790%2C%201234%20)%2C%0A%09%09Variables(%0A%09%09%09X(%20%3APROC%20)%2C%0A%09%09%09X(%20%3ACoreVoltage%2C%20Position(%201%20)%20)%2C%0A%09%09%09Y(%20%3A%22Freq1%22n%20)%0A%09%09)%2C%0A%09%09Elements(%0A%09%09%09Position(%201%2C%201%20)%2C%0A%09%09%09Heatmap(%20X(%201%20)%2C%20X(%202%20)%2C%20Y%2C%20Legend(%202%20)%2C%20Label(%20%22Label%20by%20Value%22%20)%20)%0A%09%09)%2C%0A%09%09Where(%20%3A%22prod%22%20%3D%3D%20prodval%5Bi%5D)%2C%0A%09%09SendToReport(%0A%09%09%09Dispatch(%0A%09%09%09%09%7B%7D%2C%0A%09%09%09%09%22PROC%22%2C%0A%09%09%09%09ScaleBox%2C%0A%09%09%09%09%7BAdd%20Ref%20Line(%202%2C%20%22Solid%22%2C%20%22Green%22%2C%20%22%22%2C%202%20)%2C%0A%09%09%09%09Add%20Ref%20Line(%206%2C%20%22Solid%22%2C%20%22Green%22%2C%20%22%22%2C%202%20)%2C%0A%09%09%09%09Label%20Row(%201%2C%20%7BInside%20Ticks(%201%20)%2C%20Show%20Major%20Grid(%201%20)%7D%20)%7D%0A%09%09%09%09%2F*Label%20Row(%20%0A%09%09%09%09%09%7BTick%20Mark(%20Label(%20%22FF%22%20)%2C%20Label(%20%220.57%22%20)%20)%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20Tick%20Mark(%20Label(%20%22FF%22%20)%2C%20Label(%20%220.62%22%20)%20)%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20Tick%20Mark(%20Label(%20%22FF%22%20)%2C%20Label(%20%220.97%22%20)%20)%7D%0A%09%09%09%09%20)%7D*%2F%0A%09%09%09)%2C%0A%09%09%09Dispatch(%0A%09%09%09%09%7B%7D%2C%0A%09%09%09%09%22Freq1%22%2C%0A%09%09%09%09ScaleBox%2C%0A%09%09%09%09%7BMin(%201440)%2C%20Max(%202440%20)%2C%20Inc(20%20)%2C%20Minor%20Ticks(%201%20)%2C%0A%09%09%09%09Label%20Row(%20%7BShow%20Major%20Grid(%201%20)%2C%20Show%20Minor%20Grid(%201%20)%7D%20)%7D%0A%09%09%09)%2C%0A%09%09%09Dispatch(%0A%09%09%09%7B%7D%2C%0A%09%09%09%22graph%20title%22%2C%0A%09%09%09TextEditBox%2C%0A%09%09%09%7BSet%20Text(%20prodval%5Bi%5D%20%7C%7C%20%22%20Freq%20vs.%20PROC%20%26amp%3B%20CoreVoltage%22%20)%7D%0A%09%09%09)%2C%0A%09%09)%0A%09)%3B%0A)%0A%0A%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-779671%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EAutomation%20and%20Scripting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779709%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779709%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHave%20you%20tried%20using%20%3AProd%20as%20a%20Page%20value%20rather%20than%20as%20part%20of%20a%20Where()%20clause%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779798%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779798%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3Edo%20you%20need%20the%20plots%20in%20separate%20windows%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779873%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779873%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EThere%20are%20many%20products.%20With%20the%20current%20setup%2C%20each%20of%20them%20will%20pop%20up%20to%20a%20separate%20window.%20Using%20page%2C%20the%20window%20will%20be%20super%20long.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779874%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779874%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EYes.%20Do%20you%20also%20recommend%20using%20Page%20for%20Prod%20%3F%20To%20use%20Page%2C%20I%20have%20to%20split%20data%20into%20smaller%20size%20chunks.%20For%20each%20smaller%20chunks%2C%20the%20pages%20will%20show%20the%20same%20x-axis.%20From%20chunk%20to%20chunk%2C%20they%20are%20different.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779887%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779887%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F59097%22%20target%3D%22_blank%22%3E%40Pandasgroupby%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EUsing%20page%2C%20the%20window%20will%20be%20super%20long.%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3Eyes%2C%20a%20huge%20issue%20of%20%22page%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20but%20it%20got%20fixed%20with%20JMP18%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FGraph-Builder-align-pages-next-to-each-other-or-as-grid%2Fm-p%2F561841%23U561841%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3EGraph%20Builder%20-%20align%20'pages'%20next%20to%20each%20other%20or%20as%20grid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20for%20up%20to%2030%20or%20100%20products%2C%20it%20should%20be%20now%20OK%20via%20page%20-%20and%20much%20easier%20to%20handle%20than%2030-%20100%20individual%20plots.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779891%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779891%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EThank%20you%20for%20pointing%20me%20to%20the%20page%20grid%20solution.%20The%20grid%20plot%20with%20page%20option%20might%20not%20work%20for%20me.%20I%20didn't%20include%20in%20the%20jsl%20the%20y-axis%20handling.%20Each%20y%20axis%20range%2C%20grid%20and%20reference%20line%20is%20different.%20I%20don't%20know%20how%20to%20handle%20y-axis%20by%20scripting%20on%20each%20page.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779948%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779948%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EYou%20might%20also%20want%20to%20consider%20using%20Local%20Data%20Filter%2C%20also%20remember%20to%20link%20axes%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1723050542215.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1723050542215.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1723050542215.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1723050542215.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1723050542215.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66929i12A3FFA1A3090E1D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1723050542215.png%22%20alt%3D%22jthi_0-1723050542215.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_1-1723050562705.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1723050562705.png%22%20style%3D%22width%3A%20342px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1723050562705.png%22%20style%3D%22width%3A%20342px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1723050562705.png%22%20style%3D%22width%3A%20342px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1723050562705.png%22%20style%3D%22width%3A%20342px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66930iE4DC628F8981D9F5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_1-1723050562705.png%22%20alt%3D%22jthi_1-1723050562705.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779950%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779950%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHi%2C%20jthi%2C%26nbsp%3B%3C%2FP%3E%3CP%3ESomehow%20my%20local%20filter%20couldn't%20filter%20the%20data.%20But%20the%20filter%20script%20works.%20I'm%20not%20sure%20the%20difference%20between%20the%20filter%20and%20%22where%22.%20To%20me%20the%20%22where%22%20is%20simpler.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EJane%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779951%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779951%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EThank%20you%20everyone%20for%20the%20suggestion.%20I%20used%20a%20different%20approach%20and%20solved%20the%20issue.%20I%20used%20python%20and%20added%20the%20missing%20values%20to%20the%20table.%20It%20created%20a%20much%20larger%20table.%20Not%20efficient%20but%20works%20for%20now.%20If%20you%20have%20other%20jmp%20recommendation%2C%20please%20let%20me%20know.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EJane%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779977%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20builder%20subset%20plots%20with%20the%20same%20axis%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779977%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E-%20no%20need%20to%20use%20python%20to%20add%20the%20missing%20values%20%3B%20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20no%20need%20to%20add%20the%20missing%20values%20if%20you%20closely%20follow%20the%20tipps%20of%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2687%22%20target%3D%22_blank%22%3E%40txnelson%3C%2FA%3E%20and%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14366%22%20target%3D%22_blank%22%3E%40jthi%3C%2FA%3E%26nbsp%3B%20%3A%20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebesides%20that%2C%20you%20could%20vote%20here%3A%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FColumn-Property-Inclusive-Values%2Fm-p%2F730865%23U730865%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%3CLI-EMOJI%20id%3D%22lia_folded-hands%22%20title%3D%22%3Amanos_unidas_para_la_oraci%C3%B3n%3A%22%3E%3C%2FLI-EMOJI%3E%20Column%20Property%3A%20Inclusive%20Values%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E...%20with%20this%20feature%20there%20is%20no%20need%20anymore%20to%20add%20any%20missing%20values.%3C%2FP%3E%3CP%3E-%20but%20actually%2C%20no%20need%20to%20vote%20anymore%20%3A%20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Graph builder subset plots with the same axis labels

Hello, 

I have a big data table and  a script to plot the subset by product. You can see the "where" in the script below.

I would like to keep the x-axis to be the same from product to product. The x-axis has two variables "PROC" and "CoreVoltage".    As you can see from the jpg file, at one "PROC", only some of the "CoreVoltage" showed up. How to show all the "PROC" and "CoreVoltage" combinations so from product to product the plots keep the same x-axis ? 

 

Names Default To Here( 1 );
dt = Current Data Table();
Summarize( dt, prodval = By( :"prod" ), );
n = N Items( prodval );
	
For(i = 1,i<=n,i ++,	
	Graph Builder(
		Size( 1790, 1234 ),
		Variables(
			X( :PROC ),
			X( :CoreVoltage, Position( 1 ) ),
			Y( :"Freq1"n )
		),
		Elements(
			Position( 1, 1 ),
			Heatmap( X( 1 ), X( 2 ), Y, Legend( 2 ), Label( "Label by Value" ) )
		),
		Where( :"prod" == prodval[i]),
		SendToReport(
			Dispatch(
				{},
				"PROC",
				ScaleBox,
				{Add Ref Line( 2, "Solid", "Green", "", 2 ),
				Add Ref Line( 6, "Solid", "Green", "", 2 ),
				Label Row( 1, {Inside Ticks( 1 ), Show Major Grid( 1 )} )}
				/*Label Row( 
					{Tick Mark( Label( "FF" ), Label( "0.57" ) ),
                    Tick Mark( Label( "FF" ), Label( "0.62" ) ),
                    Tick Mark( Label( "FF" ), Label( "0.97" ) )}
				 )}*/
			),
			Dispatch(
				{},
				"Freq1",
				ScaleBox,
				{Min( 1440), Max( 2440 ), Inc(20 ), Minor Ticks( 1 ),
				Label Row( {Show Major Grid( 1 ), Show Minor Grid( 1 )} )}
			),
			Dispatch(
			{},
			"graph title",
			TextEditBox,
			{Set Text( prodval[i] || " Freq vs. PROC & CoreVoltage" )}
			),
		)
	);
)

10 REPLIES 10
hogi
Level XII

Re: Graph builder subset plots with the same axis labels

- no need to use python to add the missing values ; )

 

- no need to add the missing values if you closely follow the tipps of @txnelson and  @jthi  : )

 

besides that, you could vote here:🙏 Column Property: Inclusive Values 
... with this feature there is no need anymore to add any missing values.

- but actually, no need to vote anymore : )