Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

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

    Support date functions in OVER context

    We need to summarize data in expression by Month(Date) ... but unfortunatly we currently cannot use MONTH function inside OVER context.
    almost 10 years ago in Spotfire / Custom Expressions 1 Future Consideration

    Add DistinctValueCount, RowCount, ValidRowCount, InvalidRowCount, MinValue, MaxValue, MinNumericValue, MaxNumericValue as column properties

    I would like DistinctValueCount, RowCount, ValidRowCount, InvalidRowCount, MinValue, MaxValue, MinNumericValue, MaxNumericValue to be available as column properties. They were available in 5.0 and earlier versions of Spotfire.
    over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Add visible description for data transformations

    When looking at a list of inline transformations, the name/description is the name of the transformation type. I user-provided description would be helpful when reviewing or modifying transformations. Currently, a user needs to open each one just ...
    over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Custom Expression Manager

    A mechanism is needed to manage and edit all custom expressions at a document level and then by reference not have to repeat them by chart or property control. Currently we employ document properties to manage large or complex expressions, and any...
    over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Add an aggregation method to find the Nth most common value

    MostCommon is a pretty useful aggregation method, for example when you have a large set of defective parts across different products and these are defective for different reasons and you want to see the most prominent error say per product. Very e...
    about 3 years ago in Spotfire / Custom Expressions 2 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 0 Future Consideration

    Mixed dataset calculations

    Need to be able to call a user defined function and pass it data from more than 1 dataset. Table lookup with interpolation/extrapolation is very valuable. Need to be able to use values from 1 dataset and lookup/interpolate in another. For Ex table...
    over 6 years ago in Spotfire / Custom Expressions 0 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.
    almost 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Short Format Customization

    Make all of the numbers in a column to be shown in the same short format. For example I have a number in the millions but I want it to show as 0.20Bn. I created a Short format saying 10^9 show billions but anything under a billion is showing the f...
    almost 10 years ago in Spotfire / Custom Expressions 0 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.