topic Re: Eval & Expr in Discussions

Eval & Expr

RosDima — Wed, 29 Mar 2017 20:10:27 GMT

Hi All,

I am trying to use next code:

x = summDt:Slot[1];
y = summDt:Slot[2];
z = summDt:Slot[3];
t = summDt:Slot[4];

New Window( "EtchRate By (Slot) - Bivariate",
V List Box(
Bivariate(
Y( :Name( "Mean(ER)" ) ),
X( :Radius ),
Fit Each Value( {Line Color( {213, 72, 87} )} ),
Where( :Slot == eval(x)),
SendToReport(
Dispatch( {}, "Bivar Plot", FrameBox, {Marker Size( 4 )} )
)
),
Bivariate(
Y( :Name( "Mean(ER)" ) ),
X( :Radius ),
Fit Each Value( {Line Color( {213, 72, 87} )} ),
Where( :Slot== eval(y) ),
SendToReport(
Dispatch( {}, "Bivar Plot", FrameBox, {Marker Size( 4 )} )
)
),
Bivariate(
Y( :Name( "Mean(ER)" ) ),
X( :Radius ),
Fit Each Value( {Line Color( {213, 72, 87} )} ),
Where(:Slot==eval(z) ),
SendToReport(
Dispatch( {}, "Bivar Plot", FrameBox, {Marker Size( 4 )} )
)
),
Bivariate(
Y( :Name( "Mean(ER)" ) ),
X( :Radius ),
Fit Each Value( {Line Color( {213, 72, 87} )} ),
Where(:Slot== eval(t) ),
SendToReport(
Dispatch( {}, "Bivar Plot", FrameBox, {Marker Size( 4 )} )
)
)
)

);

But have issue with Eval function, how can I use it to show specific values from DT? I want to use Slot number without knowing it before each use, I know that I have 4 different Slot numbers and for each one need to build graph.

Thanks.

Re: Eval & Expr

ms — Thu, 30 Mar 2017 09:56:26 GMT

It should work without Eval(). Make sure that dt is the current data table or send the Bivariate() command to dt explicitly.

Example:

dt = Open("$SAMPLE_DATA/Big Class.jmp");
dtsum = dt << summary(Group(sex));

x = dtsum:sex[1];
y = dtsum:sex[2];

New Window("Height By Weight - Bivariate",
    V List Box(
        dt << Bivariate(Y(:height), X(:weight), Where(:sex == x)),
        dt << Bivariate(Y(:height), X(:weight), Where(:sex == y))
    )
);

//Alternative using By(), if all "slots" are to be graphed
New Window("Height By Weight - Bivariate",
    V List Box(dt << Bivariate(Y(:height), X(:weight), By(:sex)))
);

Re: Eval & Expr

RosDima — Sat, 01 Apr 2017 17:15:06 GMT

Hi,

Instead of number it I am getting :sex==x, my goal to get :sex==Expr(x) ==> :sex==1, in case x=1

Thanks

Re: Eval & Expr

stephen_pearson — Mon, 03 Apr 2017 07:28:39 GMT

Please can you give more details about what your final report should look like? Can you explain why the answer MS gave is not suitable? Have you tried using the Dashboard builder with local data filters on each graph?