cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Hamal22
Level I

If statement inside a graph with recalc option

Hi,

I have a graph that I want to add target line per if statement (depends on user filters).

1. how to apply IF inside the graph code?

2. how to make the graph recalc and create the needed ref line?

 

example (the bold is not working):

Bivariate(
Y( :raw_value ),
X( :ah_attribute_value ),
Automatic Recalc( 1 ),
SendToReport(
if (:FE_BE[N Row(dt)] == "FE",
Dispatch({},  "2", ScaleBox, {Add Ref Line( 10, "DashDot", "Red", "2 weeks", 2)}),
Dispatch({},  "2", ScaleBox, {Add Ref Line( 5, "DashDot", "Red", "2 weeks", 2)})
),
 
Dispatch(
{},
"1",
ScaleBox,
{Label Row( Label Orientation( "Angled" ) )}
),
Dispatch(
{},
"Bivar Plot",
FrameBox,
{Frame Size( 472, 387 ),Row Legend(
chamber,
Color( 1 ),
Color Theme( "JMP Default" ),
Marker( 0 ),
Marker Theme( "Alphanumeric" ),
Continuous Scale( 0 ),
Reverse Scale( 0 ),
Excluded Rows( 0 )
)}
)
 
), 
 
);
1 REPLY 1
jthi
Super User

Re: If statement inside a graph with recalc option

Those are evaluated when the plot is created and they won't be re-evaluated later. You could (maybe) use graphic script to display the lines. Even easier could be to use Graph Builder and add extra lines to your data with extra columns to indicate the reference line values.

-Jarmo