There are at least three areas that I can currently create a calculated value.
Text Areas
Inputs for Data Function
Graphical Tables
However, if I want to have a Document Property to contain a calculated value, I can't do it without running some ...
Save expressions /formulars in a central location in the library
In the section where you can insert calculated columns you can re-use previously used expressions. This is a handy feature. However, it shows all recent expressions. There is no option to include only the ones you want to be remembered. Hence Spot...
Calculated Columns are powerful but often not useful if they don't recalculated based on filtered data. We've developed scrips to flag filtered records and calculate over that flag but this requires the user to click a button every time they filte...
should be telling us invalid part of the custom expression visually, not in writting
When an expression written in the custom expression is incorrect or when a function is invalid, an error is displayed with a red exclamation mark which telling us wrong part in writting, not visually. However it is not clear which part of the expr...
please add logical function any() / all() to calculate any(true,false,false) => true any(fale,false,false) => false all(true,true,true) => true all(true,true,false) => false Currently we can sum them and compare to the count to do the ...
As a user, I want to be able to sort columns including various date formats in order to view data in chronological or reverse chronological order. Should support major date formats including: January 2012January 2 20122 January 20122012 January 21...
I need to show the average of the row values in a cross table. The only option is a total as a sum, but what I really need is the average. In Tableau I could do this easy, when will Spotfire add this?
*Goal:*As an author, I need to control the exact format of my data so that I can properly configure the rest of my analysis. Regional language and cultural settings are client dependent and therefore dates and decimal separators change depending o...
OVER expressions are extremely powerful since they can achieve the same slicing and dicing of data which you can achieve using pivot transformations but in are more interactive way operating on subsets of data tables. At the same time most users w...
