cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
Pandasgroupby
New Member

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" )}
			),
		)
	);
)

1 REPLY 1
txnelson
Super User

Re: Graph builder subset plots with the same axis labels

Have you tried using :Prod as a Page value rather than as part of a Where() clause?

Jim