Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4803

Community Expression in Product

Let's allow expression functions to be contributed by the community. Allow pluggable expression code; Python or IronPython or Spotfire expression syntax; Needs new API
over 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

Improve Lag/Lead Functions

Now implemented but documentation doesn't specify how the ordering of rows is important; in addition, the ordering of rows is not guaranteed, so the functions are not trustworthy at present
over 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

Concatenate for external data Oracle

I have connected to Oracla table using custom query and keeping data external. I would like to create a calculated column using Concatenate, but both concat([column1],[column2) and Concatenate([column1],[column2) are not accepted by the expression...
over 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

Remove comments from resulting expression

The resulting expression rendering box is very useful to me when debugging or creating custom expressions. It would be nice not to render the comments on my custom expression on the resulting expression box as shown here
over 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

Allowing for DateTimeNow() for UTC expression

Having analysts working in different time zones, it would be helpful to have an easier way to link data from different time zones and to use UTC when analyzing the data.
almost 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add a "Proper" function

The upper and lower functions are very useful. It would be helpful to also have a "proper" function similar to what is done within Excel to convert the first character of each word to upper case and all other characters to lower case.
about 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Fix reaction of Sn() to (Empty) values

There are some (Empty) values resulting from joins e,g, within Graphical table to which SN() does not apply. See this thread https://community.tibco.com/questions/empty-value-does-not-react-sn
about 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used

DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used is not available when Keep data external option is selected in connector. This limits the usage of Spotfire.
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Expression Editor Enhancements - Hover-over information for functions

Multiple teams in our organization struggle with using the expression editor. One enhancement that gets mentioned is some kind of hover-over, context sensitive help when editing expressions. For example, hovering over a function name for >2 sec...
about 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add support for quick calculations to Count/Unique e.g. cumulative sum based on count, difference based on counts

If you are working with a String column e.g. Product Name and you are looking at a unique count of product name by time, you can easily see how many unique products were sold e.g. per month. However, if you want to look at the cumulative unique pr...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration