How to use Variables for Custom Quantiles

HubP_SDe

Dear Community,

 

I've been struggling for a while now, looking for a way of replacing the hardcoded values 0.95 and 0.99 below, with variables in an Application.

 

	Continuous Distribution(
		Column( Eval( colSelect ) ),
		Horizontal Layout( 0 ),
		Histogram( 0 ),
		Vertical( 0 ),
		Std Error Bars( 1 ),
		Count Axis( 1 ),
		Show Percents( 1 ),
		Show Counts( 1 ),
		Axes on Left( 1 ),
		Outlier Box Plot( 0 ),
		Set Bin Width( 1 ),
		Custom Quantiles( <FONT color="#339966"><STRONG>0.95, [0.95, 0.99]</STRONG></FONT> ),
<EM>//		Custom Quantiles( <FONT color="#FF0000">( Eval( Percent1 ) /100 ), [( Eval( Percent1 ) /100 ), ( Eval( Percent2 ) /100 )]</FONT> ),</EM>		Customize Summary Statistics(
			Std Err Mean( 0 ),
			Upper Mean Confidence Interval( 0 ),
			Lower Mean Confidence Interval( 0 ),
			Minimum( 1 ),
			Maximum( 1 )
		)
	),

This Dialog script comes with a set of custom variables, including the column to be analyzed ("colSelect"), and two Percentile values, that are all well retrieved (Show(), earlier in same script):

 

dt = DataTable("Dep0Times_Overall_IST5000");<BR />colSelect = "Total Time From Entrance Queue To First Pre-Sortation";<BR />Percent1 = 95;
Percent2 = 99;

Whether I try the red line above with or without the Eval() method, I get the same annoying error below:

Invalid matrix token.
Line 50 Column 49: ...val( Percent1 ) /100 ), [►( Eval( Percent1 ) /100 )...

Thanks!

HubP_SDe

Jim & all,

This finally works (maybe not the most elegant syntax)

Percent1 = 95;<BR />Percent2 = 99;<BR />percentMatrix = <FONT color="#008000">Matrix( {{ Percent1 /100 }, { Percent2 /100 }} )</FONT>;<BR />percentMatrix = [<FONT color="#008000">0.95, 0.99</FONT>];<BR />...<BR /> Custom Quantiles( ( Percent1 /100 ), percentMatrix ),<BR />

instead of:

percentMatrix = <FONT color="#FF6600">Matrix( Percent1 /100 ) || Matrix( Percent2 /100 )</FONT>;<BR />percentMatrix = [<FONT color="#008000">0.95</FONT> <FONT color="#FF6600">0.99</FONT>]

Cheers!