Hi all,
I'm trying to do a few different things on a bivariate graph and need a bit of assistance. First off, I have a data table which contains the values along with the control limits and I want to create a bivariate plot which, depending what I select on the local data filter, will update the graph with the corresponding UCL/LCL limits as a reference line. Second, I also would like to know how to get the legend to auto update based on my selection instead of having every parameter. Third, is there a way to get the Y axis to auto-scale based on my selection? The values for my application range quite a bit so I would like the y-axis to auto scale. Thanks in advance for your help. Below is a sample of what I have so far:
Bivariate(
Y( :Value ),
X( :Date ),
Automatic Recalc( 1 ),
Fit Line( {Line Color( {213, 72, 87} )} ),
Local Data Filter( Conditional, Add Filter( columns( :Parameter ), Where( :Parameter == "Length" ) ) ),
SendToReport(
Dispatch(
{},
"2",
ScaleBox,
{Add Ref Line( 28.333333, "Solid", "Black", "LCL", 1 ), Add Ref Line(
Column( "UCL" )[1],
Dotted,
{0, 255, 0},
"ENG UCL (" || Char( Column( "UCL" )[1] ) || ")"
), Add Ref Line( Column( "LCL" )[1], Dotted, {0, 255, 0}, "ENG LCL (" || Char( Column( "LCL" )[1] ) || ")" ),
Add Ref Line( Column( "Target" )[1], Dotted, {0, 255, 0}, "ENG TGT (" || Char( Column( "Target" )[1] ) || ")" )}
),
Dispatch(
{},
"Bivar Plot",
FrameBox,
{Row Legend(
Parameter,
Color( 1 ),
Color Theme( "JMP Default" ),
Marker( 0 ),
Marker Theme( "" ),
Continuous Scale( 0 ),
Reverse Scale( 0 ),
Excluded Rows( 0 )
)
}
)
)
)
