Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

    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

    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

    Change the DateDiff function so that it returns int instead or real and doesn't return factional numbers

    Currently, the DateDiff function factors in the fraction of the whole when returning the differences between year, quarter, month, etc. This can be confusing and hard to use when trying to calculate the differences between months as it will return...
    about 7 years ago in Spotfire / Custom Expressions 0 Will not implement

    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 ...
    almost 11 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 "#.# %"' ?)"
    almost 11 years ago in Spotfire / Custom Expressions 0 Future Consideration

    [Current Filtering] available in calculated column

    Would be nice to be able to adjust a calculated column in an OVER expression using the current filtering
    about 9 years ago in Spotfire / Custom Expressions 1 Will not implement

    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

    Hide Repeating Hierarchy Levels

    Flat ragged hierarchies often repeat values at lower levels due to different drill down paths. It would be very nice to have the options to hide levels if the parent has the same value. Currently I have to click down through many repeating levels ...
    almost 10 years ago in Spotfire / Custom Expressions / Filters 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 4 years ago in Spotfire / Custom Expressions / Filters 0 Future Consideration

    Move the 'freeze Column' button away from the 'Edit' button for calculated fields

    I can't tell you how many times I've accidentally clicked the Freeze Column button in an analysis. This causes the data table to become embedded, and there is no way to un-embed it. Thus I lose would, and because there's no version control in Spot...
    over 10 years ago in Spotfire / Custom Expressions 1 Future Consideration
    The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group LLC. All rights reserved. This page and your use is governed by these Terms of Use.