Analytics tools tips and tricks

Spotfire web player does not support compatibilty mode, and you may see blank pages when opening the spotfire library in your browser window. To ensure that the Web Player site is not being displayed in "Compatibility View". This is how you edit the Web Player server: On the Web Player Server: 1.      Start Microsoft IIS Manager. 2.      Click on the Web Player website. 3.      Open up the HTTP response header settings. 4.      Add a setting with name="X-UA-Compatible" and value="IE=edge" . Note: If the c ompatibility mode is disabled from the Web Player Server-side no action from the clients using the Web Player is required,  i.e., end users can continue using Internet Explorer with their standard configuration Please note this is solution to one of the causes and you may need to add the site to trusted zones or allow scripting depending on your infrastructure settings.

Personalized in-db connectors for version 6.5 and further Go to File >> Add Data Tables >> Select Connection to "SQL Server" (This could be any database type that supports custom queries) In the next dialog, provide server authentication method, username password as required. Hit the connect button If connection is successfull you should be able to select a database Select a database and in the "Views in Connection" windows select Custom Query >> New Custom Query In the Query window, add a query name, then at the bottom hit the parameters tab and check the box at the bottom "User parameters for personalized Queries" Then write in the query, you can use parameters like ?current_user, ?current_group or ?current_domain. These values are filled up by spotfire at run time based on User login information and can be used to restrict data based on user access. Add caption

You can include any additonal Statistical methods using Open Source R, Tibco Enterprise Runtime for R, SAS, Matlab Avg(Arg1, ...) ChiDist(Arg1) ChiInv(Arg1) Count(Arg1) CountBig(Arg1) Covariance(Arg1, Arg2) FDist(Arg1) FInv(Arg1) First(Arg1) GeometricMean() IQR(Arg1) L95(Arg1) Last(Arg1) LAV(Arg1) LIF(Arg1) LOF(Arg1) Max(Arg1, ...) MeanDeviation(Arg1, ...) Median(Arg1) MedianAbsoluteDeviation(Arg1, ...) Min(Arg1, ...) NormDist(Arg1) NormInv(Arg1) NthLargest(Arg1, Arg2) NthSmallest(Arg1, Arg2) Outliers(Arg1) P10(Arg1) P90(Arg1) PctOutliers(Arg1) Percent(Arg1, Arg2) Percentile(Arg1, Arg2) Q1(Arg1) Q3(Arg1) Range(Arg1) StdDev(Arg1) StdErr(Arg1) TDist(Arg1) TInv(Arg1) TrimmedMean(Arg1, Arg2) U95(Arg1) UAV(Arg1) UIF(Arg1) Uniqu

You can include any additonal Statistical methods using Open Source R, Tibco Enterprise Runtime for R, SAS, Matlab Data relationships Linear regression (numerical vs numerical),  Spearman R (numerical vs numerical), Anova (numerical vs categorical),  Kruskal-Wallis (numerical vs categorical)  Chi-square (categorical vs categorical). Hierarchical Clustering UPGMA WPGMA Single Linkage Complete Linkage Ward's Method Hierarchical Clustering Distance Measures Correlation Cosine Correlation Tanimoto Coefficient Euclidean Distance City Block Distance Square Euclidean Distance Half Square Euclidean Distance Regression Modelling Linear Regression Regression Tree Method Classification Modelling Logistic Regression Method Classification Tree Method