Month: November 2014

Spotfire: Show/Hide Regression Line (Straight Line Fit)

Posted on Updated on

The Straight Line Fit from Lines & Curves could be customized and shown/hidden as per requirement.

Below is a Scatter plot used to add a straight line fit.

ShowHide_Regression_Line_1

Make sure that the Straight Line Fit is the first fitting model in Lines & Curves (to use the script below).

ShowHide_Regression_Line_3

Add a button with script as below. In the previous step, since the first fitting model is our Straight Line Fit, we refer it in the script as FittingModels[0]. If your Straight Line is the second fitting model, you could refer it as FittingModels[1] and so on. Additionally, we need to pass the Scatter Plot as Visualization input vis to the script.

ShowHide_Regression_Line_4

IronPython Script:

from Spotfire.Dxp.Application.Visuals import ScatterPlot
for fm in vis.As[ScatterPlot]().FittingModels:
for vis in Application.Document.ActivePageReference.Visuals:
if vis.Title == "Sales by Profit":
if vis.As[ScatterPlot]().FittingModels[0].Enabled == True:
vis.As[ScatterPlot]().FittingModels[0].Enabled = False
else:
vis.As[ScatterPlot]().FittingModels[0].Enabled = True

Now you can use the button to toggle and show/hide the regression line.

ShowHide_Regression_Line_2

Advertisements

Spotfire: Changing Time Hierarchy using Multiple Date Columns

Posted on Updated on

When using multiple date columns (switched using property control) on a particular axis, we lose the ability to change the time dimension of the date selected. In order to overcome this issue, we can add a Time Hierarchy property control (a slider) and use it to alter the date column’s time hierarchy.

We start off by building a property control for changing date column. An important note here is to provide the Value as exact literals of the column name which you want to use against a Display Name. 

Change_Time_Hierarchy_3

Then we create a TimeHierarchy slider control to navigate across three dimensions – Year, Quarter and Month.

Change_Time_Hierarchy_4

And apply the below custom expression on the date column.

Change_Time_Hierarchy_5

This customization allows us to change the Time Hierarchy for Date columns. Below is a view of quarterly Sales (by Order Date)

Change_Time_Hierarchy_2

And a monthly Sales view (using Dispatch Date)

Change_Time_Hierarchy_1

K-Means Clustering using Spotfire

Posted on Updated on

To perform K-Means clustering in Spotfire, we need an appropriate line chart on which the clustering calculation could be performed.

Below we are using a simple line chart with Sales on Y-axis (a single column and not a custom expression with multiple columns) and Order Date on X-axis.

K-Means_Cluster_1

The Euclidean distance is used to perform the clustering with maximum number of clusters to be 9.

K-Means_3

Here is a segmented view of similar product sub-categories which fall in clusters depending on their sales performance.

K-Means_Cluster_2