Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

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

    Add a Random Function

    Hello We need a real random function, that would create a random integer number for each line of our data table. Every time the user would open a DXP file, the random generated would be different. We tried with Rand(count()), but the numbers gener...
    over 8 years ago in Spotfire / Custom Expressions / Data Management 0 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"...
    almost 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Time zone conversion function

    Currently we have the timezone conversion set up on database side, but if the user wants to change the timezone, then this will restart the pain stacking data import. One can solve it robustly by adding timezone difference with the DateAdd functio...
    about 9 years ago in Spotfire / Custom Expressions 1 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 10 years ago in Spotfire / Custom Expressions 0 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 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 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.
    about 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
    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.