Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

AI support for creating custom expressions

I would like help to build Spotfire custom expressions for visualizations and calculated columns, especially more complex ones using OVER. This would make me more productive with Spotfire.
20 days ago in Spotfire / Custom Expressions Future Consideration

Provide The Ability to Insert / Move "Add Calculated Columns" at Data Table Level

When we use data transformations "Calculate New Column", you have the ability to move or insert as needed. However at the Data Table level, you can only Add Calculated Column one at time. You do not have the ability to Insert / Move them. It would...
about 2 months ago in Spotfire / Custom Expressions 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 Future Consideration

Skewness function

I would appreciate an easy way to calculate the Skewness of data, for example for comparing data sets.
almost 2 years ago in Spotfire / Custom Expressions Planning to implement

Kurtosis function

I would appreciate a simple way to calculate the Kurtosis for data in order to compare the distributions of different categories of data.
almost 2 years ago in Spotfire / Custom Expressions Planning to implement

Add in the operator/function Between

SQL has a Between option. Spotfire could also benefit from a Between. We would use Between in case statements, if statements, or as standalone logic. Today we write: If([Data] >=1 and [Data] <= 2,true,false) This could be updated to be:If(Be...
about 2 years ago in Spotfire / Custom Expressions Future Consideration

add function to update the value of document property

Please add function to update the value of document property from custome expression & calculated columns, it's very helpful in some use cases if we can assign value from data table to document property.
about 2 years ago in Spotfire / Custom Expressions Future Consideration

Make a Property's DisplayName usable in custom expressions

When using properties in custom expressions, one can only use the value of the property, not the DisplayName. This would be extremely useful to allow interaction with the DisplayName, particularly when using Expressions in Properties.
about 2 years ago in Spotfire / Custom Expressions Future Consideration

GUI interface for OVER expressions

OVER expressions are extremely powerful since they can achieve the same slicing and dicing of data which you can achieve using pivot transformations but in are more interactive way operating on subsets of data tables. At the same time most users w...
over 2 years ago in Spotfire / Custom Expressions 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...
over 2 years ago in Spotfire / Custom Expressions Future Consideration