Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 144 of 4260

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...
over 3 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...
almost 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...
almost 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...
about 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.
about 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...
about 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...
about 4 years ago in Spotfire / Custom Expressions 1 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...
over 4 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

Automatic renaming of column names in expressions and transformations when replaced and matched with new columns name

Whenever we change that column name in the data source, we get the option to match the old column names against the new ones, but the column name does not change automatically in expressions and transformations. Our client has raised this request
over 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

Spotfire Analyst - Get the "Display Name" of expressions set from Property Control

When using a Property Control based on a drop-down selection, where the "Set property value through" = Expressions, there is no way currently to get the "Display Name" values. These values can be re-used in Custom Expressions for example. Thank yo...
over 4 years ago in Spotfire / Custom Expressions 0 Future Consideration