topic Re: how to remove "Where" from graph builder report window in Discussions

how to remove "Where" from graph builder report window

samshaw — Sun, 29 Jul 2018 09:20:19 GMT

Hello,

I have a script, that creates multiple graphs by parameter and put them in a report window.

the output creates a text above the outline box "Where parameter=param", i would like to remove that. how can i do that?

this is the snippet of relevant code:

graph = panel Box();

Build_chart = Function( {param},
	gb = dt1 << Graph Builder(
		Size( 1024, 725 ),
		Show Control Panel( 0 ),
		Auto Stretching( 0 ),
		Automatic Recalc( 1 ),
		Variables( X( :pm_start_date ), Y( :task_value ),Group X( :parameter ),
		Elements( Points( X, Y, Legend( 1 ), Jitter( 1 ) ), Smoother( X, Y, Legend( 2 ) ) ),
		Where( :parameter == param ) 

	)
			
);

For( j = 1, j <= N Items( param_list ), j++,
	graph << append( Report( Build_chart( param_list[j] ) ) )
);

 
chartreport = New Window( "test ",
	ob = H List Box( graph)
);

Thanks in advanced!

Re: how to remove "Where" from graph builder report window

txnelson — Sun, 29 Jul 2018 12:53:38 GMT

All you need to do, is to find the top of the display tree, and then delete the first text box, which is the display of the Where clause. See below

graph = panel Box();

Build_chart = Function( {param},
	gb = dt1 << Graph Builder(
		Size( 1024, 725 ),
		Show Control Panel( 0 ),
		Auto Stretching( 0 ),
		Automatic Recalc( 1 ),
		Variables(
			X( :pm_start_date ),
			Y( :task_value ),
			Group X( :parameter ),
			Elements( Points( X, Y, Legend( 1 ), Jitter( 1 ) ), Smoother( X, Y, Legend( 2 ) ) ),
			Where( :parameter == param )
		)
	);
	tp = Report( gb ) << topparent;
	tp[Text Box( 1 )] << delete;
);

For( j = 1, j <= N Items( param_list ), j++,
	graph << append( Report( Build_chart( param_list[j] ) ) )
);

 
chartreport = New Window( "test ",
	ob = H List Box( graph)
);

Re: how to remove "Where" from graph builder report window

samshaw — Sun, 29 Jul 2018 19:49:57 GMT

amazing!! it worked!!

this is the part i was missing

<<topparent;

what does it do?

thank you again!

Re: how to remove "Where" from graph builder report window

txnelson — Sun, 29 Jul 2018 20:05:59 GMT

The definition, taken from the Scripting Index, for Top Parent is

Returns the root parent of the Display Box