Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

    IFERROR Function

    Adding a IFERROR function (similar to the one in Excel). This helps when analyzing data and prevent dividing by zero issue.
    about 4 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.
    about 4 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...
    about 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Community Expression in Product

    Let's allow expression functions to be contributed by the community. Allow pluggable expression code; Python or IronPython or Spotfire expression syntax; Needs new API
    about 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Improve Lag/Lead Functions

    Now implemented but documentation doesn't specify how the ordering of rows is important; in addition, the ordering of rows is not guaranteed, so the functions are not trustworthy at present
    about 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Concatenate for external data Oracle

    I have connected to Oracla table using custom query and keeping data external. I would like to create a calculated column using Concatenate, but both concat([column1],[column2) and Concatenate([column1],[column2) are not accepted by the expression...
    about 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Remove comments from resulting expression

    The resulting expression rendering box is very useful to me when debugging or creating custom expressions. It would be nice not to render the comments on my custom expression on the resulting expression box as shown here
    over 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Add a "Proper" function

    The upper and lower functions are very useful. It would be helpful to also have a "proper" function similar to what is done within Excel to convert the first character of each word to upper case and all other characters to lower case.
    almost 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Fix reaction of Sn() to (Empty) values

    There are some (Empty) values resulting from joins e,g, within Graphical table to which SN() does not apply. See this thread https://community.tibco.com/questions/empty-value-does-not-react-sn
    almost 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

    DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used

    DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used is not available when Keep data external option is selected in connector. This limits the usage of Spotfire.
    about 9 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.