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)

Spotfire Cross table sub total

in vertical axes add below expression for Avg percentage Avg([Counts]) / First([Counts]) in vertical axes add below expression for total value Sum([Counts]) / First([Counts])

Spotfire Migration steps

Migrate an Information Model to point to a new database We now have quite a few customers who are actively trying to migrate from a Test Spotfire Server to a Production Spotfire Server. The issue is that in many cases they want the Data Source on Test to point to \\test-database and they want a Data Source with the same GUID on Production to point to \\production-database . These instructions are for Spotfire Server 3.0 only and require separate Test and Production servers of Spotfire Server (SS). Start with a Data Source (DS), Information Elements (IEs), an Information Link (IL) and DXP file that uses that IL on the Test Spotfire Server (TSS). DS points to \\test-database and is in a different SS folder that the IEs, IL or DXP file. Export the folder on the Test SS that contains the DS Import that folder on to the Production SS, choosing the option to maintain GUIDs Modify DS on the Production SS so the connect string points to \\production-database After this step do not migrate the DS again to the Production DSS Export the folder on the Test SS that contains the IEs, IL and DXP file Import that folder on to the Production SS When you open the DXP file from the Production SS Library it should connect to DS through the \\production-database http://spotfirecommunity.tibco.com/community/blogs/stn/archive/2009/12/03/migrate-an-information-model-to-point-to-a-new-database.aspx

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