I am controlling a ScatterPlot from an IronPython script in Spotfire.
I can not find the necessary property or object to create or control "Line from Column" created using the "Lines & Curves" option in a scatter plot. (see attached image):
My script is attached, it all works really well except the last line where I need help.
from Spotfire.Dxp.Application.Visuals import VisualContent
from Spotfire.Dxp.Application.Visuals import ScatterPlot
if yAxisNormalization == "Norm0" and yAxisAllorAverage == "Individual":
#======= Norm0, Individual
sTitle = "Individual Values Normalized To Baseline"
sYAxisFormula = "Avg([val_t0_offset]) Over (Intersect([Week],[Subj_ID]))"
sErrorBars = "StdDev([val_t0_offset]) over (Intersect([Subj_ID],[Week]))"
elif yAxisNormalization == "Norm0" and yAxisAllorAverage == "Average":
#======= Norm0, Average
sTitle = "Treatment Averaged Values Normalized To Baseline"
sYAxisFormula = "Avg([val_t0_offset]) Over (Intersect([Week],[Treatment]))"
sErrorBars = "StdDev([val_t0_offset]) over (Intersect([Treatment],[Week]))"
elif yAxisNormalization == "NotNorm" and yAxisAllorAverage == "Individual":
#======= No Normalizaiton, Individual, just raw
sTitle = "Individual Measured Values"
sYAxisFormula = "Avg([Val]) Over (Intersect([Week],[Subj_ID]))"
sErrorBars = "StdDev([Val]) over (Intersect([Subj_ID],[Week]))"
elif yAxisNormalization == "NotNorm" and yAxisAllorAverage == "Average":
#======= No Normalizaiton, Averaged data
sTitle = "Treatment Averaged Values"
sYAxisFormula = "Avg([Val]) Over (Intersect([Week],[Treatment]))"
sErrorBars = "StdDev([Val]) over (Intersect([Treatment],[Week]))"
# ======================= setup line connection based on aggrigation ==========================
if yAxisAllorAverage == "Individual":
sLineConnection= "<[Subj_ID]>"
elif yAxisAllorAverage == "Average":
sLineConnection= "<[Treatment]>"
if yAxisNormalization == "NotNorm":
sOutlierValue = "<[val_t0_offset]>"
elif yAxisNormalization == "Norm0":
sOutlierValue= "<[Val]>"
#set the title
visual.Title = sTitle
#set the Y formula
scatterPlot = visual.As[ScatterPlot]()
scatterPlot.YAxis.Expression = sYAxisFormula
#ERROR BARS
scatterPlot.YAxis.ErrorBars.UpperExpression = sErrorBars
scatterPlot.YAxis.ErrorBars.LowerExpression = sErrorBars
scatterPlot.YAxis.ErrorBars.Enabled = True
# ------ redifine line connection ------------------
scatterPlot.LineConnection.ConnectionAxis.Expression = sLineConnection
# ---- change grey outlier bars ---------------------
######### NEED HELP HERE! ##############################
# how do I set the Yvalue for a Line created in Lines and Curves? ###
scatterplot.(linesAndCUrves??).(line[0]?).YvaluesColumn = sOutlierValue <<<this is the line where I need help.
#############################################################
#############################################################
I haven't used this personally, but I think you want the FittingModelCollection object, specifically the method AddColumnValuesLine.