Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 143

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

Add preferences/options on how null values should be default handled.

Add an option to Spotfire that allow you to configure how NULLs are handled when used in expressions and calculations. For instance I would like the option to specify that when using an expression or calculation, that NULLs are treated as empty st...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Fiscal week method

The customer would like to be able to use fiscal week in addition to the other fiscal options
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Random Sample data as Transformation option

Don't think this is currently possible. Currently, to do a random sample, I create a calculated column for random value like Rand(1). Then I filter the data to my sample size (e.g. I filter out 0.0 to 0.7 if I want a random sample that's 30% of th...
about 5 years ago in Spotfire / Custom Expressions 5 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.
over 2 years ago in Spotfire / Analytics / Custom Expressions 0 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( 'incre...
over 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

Net Present Value (NPV) Function

No description provided
almost 2 years ago in Spotfire / Custom Expressions 0 Future Consideration

Utilize Curve Fit Result directly in another visualization.

Consume the data retrieved from “Export Curve Fit Result” directly without the need to export it and re-import it back to the analysis itself.
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

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 ...
about 8 years ago in Spotfire / Custom Expressions 0 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
about 6 years ago in Spotfire / Custom Expressions 0 Future Consideration