Spotfire
Information for the TIBCO Spotfire platform
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
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
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
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
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
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
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
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
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
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