TIBCO Spotfire Application Data Services

http://ec2-23-21-157-174.compute-1.amazonaws.com/products/application-data-services.aspx

Active Space in Spotfire

http://spotfirecommunity.tibco.com/community/forums/p/4993/17518.aspx#17518

Create New Column on spotfire Data table using python script

curDT = Document.ActiveDataTableReference cols = curDT.Columns #targetCol = Document.Properties["myColumnSelection"] #Create a new column that counts the comma delimiter myExpression = "sum([Goods]) over([statecode])" myNewColName = cols.CreateUniqueName("TotalRevenue") cols.AddCalculatedColumn(myNewColName, myExpression)

Select Deselect all values using python script in Spotfire

from Spotfire.Dxp.Application.Filters import CheckBoxHierarchyFilter plFilter=Document.FilteringSchemes[1].Item[tab].Item[tab.Columns.Item["Region"]].As[CheckBoxHierarchyFilter]() if Document.Properties.Item["Status"]=="All": plFilter.UncheckAllNodes() Document.Properties.Item["Status"]="None" else: plFilter.CheckAllNodes() Document.Properties.Item["Status"]="All"

Finding Previous value in bar chart spotfire

(Sum([PRINCIPALAMTINTRADECURR]) - Sum([PRINCIPALAMTINTRADECURR]) OVER (Previous([Axis.X]))) / Sum([PRINCIPALAMTINTRADECURR]) OVER (Previous([Axis.X]))