Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 137

Separate the StdDev function/aggregation like Excel function

Hello, This is Nagwon Jeong. I would like to suggest one function/aggregation. In Excel, there are STDEV.P, STDEV.S, STDEVA, and STDEVPA functions to obtain the standard deviation. And the function/aggregation to get the standard deviation in ...
almost 6 years ago in Spotfire / Custom Expressions 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...
almost 9 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
over 6 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 2 years ago in Spotfire / Custom Expressions 1 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.
almost 9 years ago in Spotfire / 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( 'increment'...
almost 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

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

Create expressions from filter selections

Creating filter expressions for individual visualizations requires manual coding. Would like an option to include current filter selections in an expression so that non-technical business users can easily reduce the dimensions included in the visu...
about 2 years ago in Spotfire / Custom Expressions / Filters 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 ...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration