CODEWITHSUNDEEP
ironpythonspotfire
mike
mike

Reputation: 2308

Need Object or Property in Spotfire.DXP that controls "Lines & Curves"

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): enter image description here

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.
#############################################################
#############################################################

Upvotes: 1

Views: 1522

Answers (2)

mike
mike

Reputation: 2308

From @niko's link, the full code to get two horizontal lines from columns was:

    sMinCol = "Test_t0_min"
    sMaxCol = "test_T0_max" 

# --- OUTLIER DEMARKATION LINES: --
oDataTable = Document.Data.Tables['all_results'] 
oXCol = oDataTable.Columns['Week'] 
scatterPlot.FittingModels.Clear() 

#lower
oYCol = oDataTable.Columns[sMinCol] 
oColumnValuesLine = scatterPlot.FittingModels.AddColumnValuesLine(oDataTable, oXCol, oYCol) 
oColumnValuesLine.AffectAxisRanges = True
oColumnValuesLine.Line.Width = 3
#upper
oYCol = oDataTable.Columns[sMaxCol] 
scatterPlot.FittingModels.AddColumnValuesLine(oDataTable, oXCol, oYCol) 
oColumnValuesLine.AffectAxisRanges = True
oColumnValuesLine.Line.Width = 3

Upvotes: 2

niko
niko

Reputation: 3974

I haven't used this personally, but I think you want the FittingModelCollection object, specifically the method AddColumnValuesLine.

Upvotes: 2

Related Questions