Spotfire

Information for the TIBCO Spotfire platform

How To - Unpivot Transformations
The purpose of an unpivot transformation is to take many columns and transform them into a single category column and a single value colum...
Mon, 31 Oct, 2016 at 11:18 AM
Problem Solving - Bookmarks
I have two bookmarks in a DXP file -- CurveDraw1 and CurveDraw2.  I recently noticed this error message when engaging each of these bookmarks my DxP file....
Mon, 31 Oct, 2016 at 3:28 PM
Tips - Select all columns in TERR
Many novice TERR users get to this screen (see first screenshot) and go through the process of adding all columns with the Select columns button.  You don&#...
Thu, 2 Feb, 2017 at 12:03 PM
How To - Pivot Transformations
Pivot transformations are used to aggregate data and also to change what constitutes a row and/or a column.  This may be necessary if you need to chang...
Mon, 31 Oct, 2016 at 11:17 AM
Problem Solving - IF statements and Month function
Somewhere between version 7.0 and 7.6, TIBCO changed how the month function.  It used to return an integer.  Now it returns "Jan", "Feb&qu...
Mon, 7 Nov, 2016 at 6:29 PM
Tips - TERR in the Spotfire menus
One of the things Spotfire is know for is overlap in functionality.  There are at least three ways to every task, and this is especially true when it comes ...
Thu, 2 Feb, 2017 at 12:09 PM
How To - Search Text
The find function and the ~= operator are excellent for searching text. The find function will search for a string of text and return the position of th...
Mon, 7 Nov, 2016 at 6:17 PM
Tips - Working with Bookmarks
Bookmarks can be quite fickly in Spotfire.  When the user creates a bookmark, versus a bookmark special, absolutely everything about the analysis is capture...
Thu, 2 Feb, 2017 at 12:22 PM
How To - Create ad hoc filters & retain marked data
Users frequently ask how they can a) create their own filters or b) retain marked data.  The same feature can handle both of these requests -- Tags.  Here...
Mon, 14 Nov, 2016 at 11:40 AM
Problem Solving -- Cell is null but does not respond to 'is null' in calculation
It occasionally happens that a cell looks blank (i.e. null), but it is a blank, not a null.  You'll know this is the case because writing if statements ...
Tue, 20 Dec, 2016 at 4:34 PM