Thread

IronPython is a popular scripting language for modifying and customizing TIBCO Spotfire. Below are some examples of how to modify chart colors in Spotfire using IronPython:

Example 1: Changing the Color of a Bar Chart Based on Column Values

from Spotfire.Dxp.Application.Visuals import BarChart
from Spotfire.Dxp.Application.Visuals import ColorRule
from Spotfire.Dxp.Application.Visuals.VisualContent import BackgroundRule

# Get the Bar Chart visualization
barChart = vis.As[BarChart]()

# Define a color rule
colorRule = ColorRule("YourColumnName", "Categorical")
colorRule.AddCategoryExpression("\"YourFirstCategory\"", Color.Yellow)
colorRule.AddCategoryExpression("\"YourSecondCategory\"", Color.Green)
colorRule.AddCategoryExpression("\"YourThirdCategory\"", Color.Blue)

# Apply the color rule to the data
barChart.ColorRules.Add(colorRule)

Example 2: Setting a Specific Color to All Bars

from Spotfire.Dxp.Application.Visuals import BarChart, ColorRule
from System.Drawing import Color

# Get the Bar Chart visualization
barChart = vis.As[BarChart]()

# Define a global color rule for all bars
globalColorRule = ColorRule(Color.FromArgb(255, 0, 128, 128)) # Teal color

# Apply the global color rule
barChart.ColorRules.Add(globalColorRule)

Example 3: Changing Line Chart Colors

from Spotfire.Dxp.Application.Visuals import LineChart, ColorRule
from System.Drawing import Color

# Get the Line Chart visualization
lineChart = vis.As[LineChart]()

# Define a color rule
lineColorRule = ColorRule("YourColumnName", "Categorical")
lineColorRule.AddCategoryExpression("\"YourFirstCategory\"", Color.Red)
lineColorRule.AddCategoryExpression("\"YourSecondCategory\"", Color.Green)
lineColorRule.AddCategoryExpression("\"YourThirdCategory\"", Color.Blue)

# Apply the color rule to the data
lineChart.ColorRules.Add(lineColorRule)

Example 4: Conditional Formatting for Background Color

from Spotfire.Dxp.Application.Visuals import BarChart, BackgroundRule
from System.Drawing import Color

# Get the Bar Chart visualization
barChart = vis.As[BarChart]()

# Define a background color rule based on a condition
backgroundRule = BackgroundRule("YourColumnName")
backgroundRule.AddCategoryExpressio
backgroundRule.AddBackgroundExpression("[YourColumnName] > 10", Color.FromArgb(255, 255, 0, 0)) # Red for values > 10
backgroundRule.AddBackgroundExpression("[YourColumnName] <= 10", Color.FromArgb(255, 0, 255, 0)) # Green for values <= 10

# Apply the background rule
barChart.BackgroundRules.Add(backgroundRule)

Important Notes:

• Replace "YourColumnName" with the actual column name in your dataset.
• Replace "YourFirstCategory", "YourSecondCategory", and "YourThirdCategory" with actual category names available in your dataset.
• Make sure to adjust the colors based on your preference by changing the ARGB values.

These examples should help you get started with modifying chart colors in Spotfire using IronPython.