Show/Hide columns dynamically in table visualization in Spotfire

Create a script with 2 scripts parameters: name: showCol type: String value: "${Control}" name: tablePlot type: Visualization value: Page > Table Script: from Spotfire.Dxp.Application.Visuals import * if showCol == 'id': cols=['ID1','ID2'] elif showCol == 'type': cols=['Type1','Type2'] else: cols=['CD1','CD2'] tablePlot.As[TablePlot]().Columns.Clear() tablePlot.As[TablePlot]().Columns.AddRange(cols)

Spotfire scripts

http://spotfired.blogspot.com/2014/07/change-date-rangefilters-porgramatically.html

Spotfire Datasource creation

1.Type: Oracle(direct client) jdbc:tibcosoftwareinc:oracle://server_instance_name:portid;SID=databaseName 2. SQL Server (2005 or newer) jdbc:sqlserver://server_instance_name:portid;

Sub Average in cross table on spotfire

[USER_ID] NEST [NETWORK] NEST Sum([Amount]) over ([USER_ID]) / UniqueCount(if([NETWORK] is null," ",[NETWORK])) over ([USER_ID]) as [Avg]

check and Uncheck CheckBox Filter in Spotfire

from Spotfire.Dxp.Application.Filters import CheckBoxFilter plFilter=Document.FilteringSchemes[0].Item[tab].Item[tab.Columns.Item["NETWORK"]].As[CheckBoxFilter]() values = plFilter.Values for value in plFilter.Values: if plFilter.IsChecked(value): plFilter.Uncheck(value) else: plFilter.Check(value)