Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Custom Expression Manager

A mechanism is needed to manage and edit all custom expressions at a document level and then by reference not have to repeat them by chart or property control. Currently we employ document properties to manage large or complex expressions, and any...
almost 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add an aggregation method to find the Nth most common value

MostCommon is a pretty useful aggregation method, for example when you have a large set of defective parts across different products and these are defective for different reasons and you want to see the most prominent error say per product. Very e...
about 3 years ago in Spotfire / Custom Expressions 2 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 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

please add logical function any() / all()

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 ...
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

Short Format Customization

Make all of the numbers in a column to be shown in the same short format. For example I have a number in the millions but I want it to show as 0.20Bn. I created a Short format saying 10^9 show billions but anything under a billion is showing the f...
almost 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

web client support for statistical tools

It would be useful to be able to invoke the Spotfire Statistical tools from the Web Client. This would allow creating new Classification and Regression Models as well as using Line similarity and Clustering.
almost 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

Set Default Color For Categories

Frequently, there are specific colors that I want to use for certain dimensions in my data. For instance, if I have credit card transaction data, and I want to break things out by 'Card Type', I should be able to set "AmEx = Green", "Visa = Blue",...
over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

Not equal to should evaluate to true if value is null

User is stating that IF statements do not handle nulls as expected in calculated columns, or in limit data by expressions on a visualisation. Here is an example: 3 rows of data: ID Value1 Complete2 3 Not Complete Where in ID 2 , the value for the ...
over 10 years ago in Spotfire / Custom Expressions 1 Future Consideration

Control over formatting anywhere a custom expression is used

It is quite inconvenient that anywhere you use a custom expression you can't specify the format at the same time (or is there an undocumented keyword for expressions such as '[Home Runs]/[Runs] as [Percentage] like "#.# %"' ?)"
over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

More methods to choose from regression modeling and classification modeling

I would like to use more methods to choose from regression modeling and classification modeling, e.g. Lasso. Also, Hyperparameter Optimization would be nice.
almost 4 years ago in Spotfire / Custom Expressions 1 Future Consideration