cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

If statement inside a graph with recalc option

Hamal22
Level I

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