How to change sparkline color on Graphical Table in Spotfire® using IronPython scripting

Introduction

The example below shows how to change the Graphical Table sparkline color.

Code sample

# Copyright © 2017. TIBCO Software Inc.  Licensed under TIBCO BSD-style license.

from Spotfire.Dxp.Application. Visuals import VisualTypeIdentifiers
from Spotfire.Dxp.Application. Visuals.Miniatures import GraphicalTable, SparklineMiniatureVisualization 
from System.Drawing import Color 

#graphPlot is a GraphicalTable visualization script parameter
#color is a string document property holding values like "red", "blue" 

for column in graphPlot.As[GraphicalTable]().Columns: 
	if column.Visualization.TypeId == VisualTypeIdentifiers.SparklineMiniatureVisualization: 
		print column.Title
		if column.Title == "Trend": 
			#column.Visualization.LineColor = Color.FromArgb(R,G,B)
			column.Visualization.LineColor = Color.FromName("Red")

References

• API Reference: Spotfire Analyst
• API Reference: SparklineMiniatureVisualization Class
• API Reference: VisualTypeIdentifiers Class

License:  TIBCO BSD-Style License

Back to IronPython Scripting in TIBCO Spotfire Examples:  https://community.spotfire.com/s/article/IronPython-Scripting-in-Spotfire