Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4367

Can you please add SIGN function to the math functions?

No description provided
almost 4 years ago in Spotfire / Custom Expressions 1 Future Consideration

Create Calculated Column from other table

Currently I don't see an option in Create Calculated Columns dialog box to create calculation based on data from other tables. It would be a lot helpful to have this feature especially when you want to create calculations based on data from multip...
almost 4 years ago in Spotfire / Custom Expressions 1 Future Consideration

Use List Document Property in SQL "IN" Statement within Custom Expressions

It would be useful to be able to pass a list type document property (e.g. "String List", "Date List", etc...) into a SQL "IN" statement in a custom expression or calculated column. This can then be used to provide input for options for consumer us...
about 4 years ago in Spotfire / Custom Expressions 3 Future Consideration

Differences between Preprocessor ($) and Document Property in custom expression

End user can insert a document property into an expression using the Insert Property option in the calculated column expression. This would add a preprocessor($) expression like ${documentproperty} When renaming a column name, the expression using...
over 4 years ago in Spotfire / Custom Expressions 1 Future Consideration

Add a Library Property option in addition to Column, Data Table, and Document Properties.

Frequently, I have information or a property that I want to share across all analyses in the library. These may contain expressions or variables to use for axis control, calculated columns, data limiting expressions etc. Rather than having to modi...
over 4 years ago in Spotfire / Custom Expressions 1 Future Consideration

Better decimal point accuracy on color rule for column created through a custom expression

I have created a percentage value as part of a custom expression - and within the Formatting menu, this field has been setup as a "Percentage". When I create a new color rule using this column, it allows me to enter decimal based values into the r...
over 4 years ago in Spotfire / Custom Expressions 2 Already exists

Spotfire Analyst - Native conversion function for date in ISO 8601 format

There is no current built in function to convert a string containing a date in ISO 8601 format. Could TIBCO create this conversion function? This would avoid using substrings and DateTime. Thank you for your consideration.
over 4 years ago in Spotfire / Custom Expressions 1 Future Consideration

Mixed dataset calculations

Need to be able to call a user defined function and pass it data from more than 1 dataset. Table lookup with interpolation/extrapolation is very valuable. Need to be able to use values from 1 dataset and lookup/interpolate in another. For Ex table...
over 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

Insert custom expression into title of visual

At the moment, it is possible to insert Dynamic Item with Calculated value into Text area. In this way you can visualize the value of arbitrary custom expression in text area. I am suggesting to have same dynamic option in the graph tittle. Usecas...
over 4 years ago in Spotfire / Custom Expressions 2 Future Consideration

Truncate Function in Spotfire

Currently I don't see a function to truncate the values while creating a calculated column. Ex. Truncating 1.56 to one value after decimal which would be 1.5 (Round function would change it to 1.6) Spotfire has a round function. But it would be gr...
almost 5 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration