Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 144 of 4260

calculate over all periods of detail levels

Lets say we have a hierarchy of Year.Month, we want to calculate sum on all the same months (e.g. March) of each year. ParallelPeriod() can only calculate on the same month of previous year.
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

should be telling us invalid part of the custom expression visually, not in writting

When an expression written in the custom expression is incorrect or when a function is invalid, an error is displayed with a red exclamation mark which telling us wrong part in writting, not visually. However it is not clear which part of the expr...
over 1 year 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.
over 1 year ago in Spotfire / Custom Expressions 1 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"...
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

add function to convert integer to ascii character and vice versa

Please add function to convert integer to ascii character and vice versa. Currently we use expression like below to do so, it's ugly & slow and can not cover all ascii chars. case when ([val]>=48) and ([val]<=57) then string([val] - 48) ...
over 1 year ago in Spotfire / Custom Expressions 1 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...
over 1 year ago in Spotfire / Custom Expressions / Filters 0 Future Consideration

Exclude Columns Transformation: Honor Exclusions Even When Data Type Changes

I want the exclude columns transformation to honor my request when I exclude column(s). I do not care if the data type changes. If I want the column excluded, then I do not want it in my data tables -- unless I specifically allow it. At the moment...
over 1 year ago in Spotfire / Custom Expressions / User Experience 0 Future Consideration

IFERROR Function

Adding a IFERROR function (similar to the one in Excel). This helps when analyzing data and prevent dividing by zero issue.
almost 2 years ago in Spotfire / Custom Expressions 0 Future Consideration

Allow transformations for external (in-db) data tables

One should have the possibility to define transformations on data canvas for external (in-db) tables. Also a possibility to review the data should be possible.
almost 2 years ago in Spotfire / Custom Expressions / Data Streams 0 Future Consideration

Do not automatically generate cluster columns after dendrogram clustering in heat map

I find it a bit annoying that cluster membership columns are automatically generated if I calculate dendrograms in a heatmap. I do this in order to group the rows/columns, not to calculate clusters. There should be an option to inactivate the colu...
almost 2 years ago in Spotfire / Custom Expressions 0 Future Consideration