Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Ideas

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 6 years ago in Spotfire / Custom Expressions 3 Future Consideration

Orthogonal Distance Regression (ODR)

Hi We would like to see the orthogonal regression as an additional comparison method under Tools-->Data Relationships to add this type of regression to the data relationship tool
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add a Random Function

Hello We need a real random function, that would create a random integer number for each line of our data table. Every time the user would open a DXP file, the random generated would be different. We tried with Rand(count()), but the numbers gener...
over 8 years ago in Spotfire / Custom Expressions / Data Management 0 Future Consideration

Favorite registration and Export/Import functions for saving time to create same expression

I need favorite registration and Export/Import functions for saving time to create same expression. Often the same calculation new column is created and applied to several different analyses. In this case, the history function "Recent expressions"...
almost 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

CORS headers for Web Input and Web Input Response (REST API)

Web Input and Web Input Response adapters provide a simple and handy way to pull up a REST API in just a few minutes. However if you want to use it from any browser, the POST requests to the API will fail because browsers implement the same origin...
over 2 years ago in Spotfire Streaming 0 Planning to implement

Filter data by expression prior to pivoting

Currently, creating a pivot table requires the entire source table to be used for the pivot when I frequently would only like a specific subset of data to be pivoted. An option to use a custom expression to filter the data prior to pivoting would ...
over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

Time zone conversion function

Currently we have the timezone conversion set up on database side, but if the user wants to change the timezone, then this will restart the pain stacking data import. One can solve it robustly by adding timezone difference with the DateAdd functio...
about 9 years ago in Spotfire / Custom Expressions 1 Future Consideration

Custom Expressions - formula in-line context

Add functionality like found in other coding languages (R, SQL, even Excel) which would show preview text when creating a new custom expression. For example: When you start typing... dateadd( you would see something like... dateadd( 'increment'...
almost 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add a dict data type to StreamBase

Currently StreamBase offers following primitive field types: bool blob int long double timestamp string The primitive types can be used in higher order structures: tuple list There are also 2 auxiliary structures: function capture group The ...
about 8 years ago in Spotfire Streaming 0 Future Consideration

Allow axis in a visualization to be used as a part of an OVER expression regardless of axis type

Currently, an axis has to be of type Categorical for it to be available in an Custom Expression with OVER() - e.g., [Axis.X] - in a given visualization. However, to add Line and Curves in the same visualization, the axis has to be Continuous. Enab...
almost 3 years ago in Spotfire / Custom Expressions 0 Future Consideration