Bar chart subsets

/

Description: Bar chart subsets.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

for s in myVisVC.Data.Subsets:
  print "Displayname: " + s.DisplayName
  print "    Manual Name: " + s.ManualDisplayName
  print "    Enabled: " + str(s.Enabled) 
  print "    Interactive: " + str(s.Interactive)

Bar chart add a subset

/

Description: Bar chart add a subset.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

NewMarkingSubset = myVisVC.Data.Subsets.AddDataSelection(Document.Data.Markings['TestMarking'])
#NewWhereClauseSubset = myVisVC.Data.Subsets.AddWhereClauseExpression()

Bar chart show/hide items

/

 

Description: Bar chart show/hide items.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

for r in myVisVC.TryGetFilterRules()[1]:
  print r.DisplayName
  print r.Enabled
  print r.Expression
  print r.EvaluatePerTrellis
  print r.ManualDisplayName
  print r.HideMatchedItems

  if (r.RuleCondition.Context.ToString() == "Spotfire.Dxp.Application.Visuals.RangeRuleCondition"):
    print "Rule Type:  " + "Range Rule"
    print "Start Display: " + r.RuleCondition.StartValueManualDisplayName  
    print "Start Value: " + r.RuleCondition.StartValue.Value.ToString()
    print "End Display: " + r.RuleCondition.EndValueManualDisplayName  
    print "End Value: " + r.RuleCondition.EndValue.Value.ToString() + "\r\n"

  if (r.RuleCondition.Context.ToString() == "Spotfire.Dxp.Application.Visuals.ExpressionRuleCondition"):
    print "Expression: " + r.RuleCondition.Expression + "\r\n"

  if (r.RuleCondition.Context.ToString() == "Spotfire.Dxp.Application.Visuals.StringRuleCondition"):
    print "String Display: " + r.RuleCondition.StringValueManualDisplayName
    print "String Value: " + r.RuleCondition.StringValue.Value + "\r\n"

  if (r.RuleCondition.Context.ToString() == "Spotfire.Dxp.Application.Visuals.ThresholdRuleCondition"):
    print "Threshold Display: " + r.RuleCondition.ThresholdManualDisplayName
    print "Threshold Value: " + r.RuleCondition.Threshold.Value.ToString() + "\r\n"

  if (r.RuleCondition.Context.ToString() == "Spotfire.Dxp.Application.Visuals.TopBottomRuleCondition"):
    print "Rank Display: " + r.RuleCondition.RankManualDisplayName
    print "Rank Value: " + r.RuleCondition.Rank.Value.ToString()
    print "Is Bottom: " + r.RuleCondition.IsBottom.ToString() + "\r\n"

Bar chart toggle error bars

/

Description: Bar chart toggle error bars.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

#Bar charts only support y-axis error bars
myVisVC.YAxis.ErrorBars.Enabled = True
#myVisVC.YAxis.ErrorBars.IndexedEnabled["Sum(Delta)"] = True #Indexed example

Bar chart error bar upper error expression

/

Description: Bar chart error bar upper error expression.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

#Bar charts only support y-axis error bars
#Notes: Delta and Value2 are column names

myVisVC.YAxis.ErrorBars.UpperExpression = "StdErr(Value2)"
#myVisVC.YAxis.ErrorBars.IndexedUpperExpression["Sum(Delta)"] = "StdErr(Value2)" #Indexed example

Bar chart error bar lower error expression

/

Description: Bar chart error bar lower error expression.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

#Bar charts only support y-axis error bars
#Notes: Delta and Value1 are column names

myVisVC.YAxis.ErrorBars.LowerExpression = "StdErr(Value1)"
#myVisVC.YAxis.ErrorBars.IndexedLowerExpression["Sum(Delta)"] = "StdErr(Value1)" #Indexed example

Bar chart error bar color

/

Description: Bar chart error bar color.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
from System.Drawing import Color
myVisVC = myVis.As[VisualContent]()

#Bar charts only support y-axis error bars
myVisVC.YAxis.ErrorBars.FixedColor = Color.FromName("red")
myVisVC.YAxis.ErrorBars.UseMarkerColor = False

Bar chart display each tooltip item

/

Description: Display each bar chart tooltip item.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent
myVisVC = myVis.As[VisualContent]()

count=-1
for t in myVisVC.Details.Items: #Display each Tooltip
  count +=1
  print "Tooltip Order:[" + count.ToString() + "]  Name:[" + t.DisplayName + "]  Visible?:[" + t.Visible.ToString() +"]"

Bar chart label visibility

/

Description: Configure bar chart label visibility (all, marked rows, or none).
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent, LabelVisibility
myVisVC = myVis.As[VisualContent]()

myVisVC.LabelVisibility = LabelVisibility.Marked
#myVisVC.LabelVisibility = LabelVisibility.All
#myVisVC.LabelVisibility = LabelVisibility.None

Bar chart data label orientation

/

Description: Configure bar chart data label orientation.
Assumptions: myVis is a visualization type script parameter.

from Spotfire.Dxp.Application.Visuals import VisualContent, LabelOrientation
myVisVC = myVis.As[VisualContent]()

myVisVC.LabelOrientation = LabelOrientation.Horizontal
#myVisVC.LabelOrientation = LabelOrientation.Vertical