Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

    Truncate Function in Spotfire

    Currently I don't see a function to truncate the values while creating a calculated column. Ex. Truncating 1.56 to one value after decimal which would be 1.5 (Round function would change it to 1.6) Spotfire has a round function. But it would be gr...
    over 6 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

    Add YearAndMonth and Trunc Funtion

    I need a year/month combination constantly for calculations like "get data between two months ago 1st of the month to the end of next month" Having either or both of these functions would make this task much easier. Yes, I can accomplish both toda...
    over 8 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

    Import a list of tags

    Create a list of tags from a table (based on values from a column) instead of raising tags one by one.
    over 10 years ago in Spotfire / Custom Expressions 5 Future Consideration

    Data Table Description

    I need the ability to add a detailed description of a data table in the Spotfire client. When I have multiple data tables in a complex analysis, it is easy to lose track of what purpose each data table serves. I experimented with adding a new Data...
    about 10 years ago in Spotfire / Custom Expressions 1 Future Consideration

    Random Sample data as Transformation option

    Don't think this is currently possible. Currently, to do a random sample, I create a calculated column for random value like Rand(1). Then I filter the data to my sample size (e.g. I filter out 0.0 to 0.7 if I want a random sample that's 30% of th...
    over 7 years ago in Spotfire / Custom Expressions 5 Future Consideration

    Create a 'List box' property control with expression within a text area using a table apart from the default table

    While working in the Property control dialog, select the property and set 'Set property value through' to 'Expressions'. However, when you attempt to Edit the Expression, only the column names from the default table are visible but not other tables.
    about 3 years ago in Spotfire / Custom Expressions 2 Future Consideration

    Add preferences/options on how null values should be default handled.

    Add an option to Spotfire that allow you to configure how NULLs are handled when used in expressions and calculations. For instance I would like the option to specify that when using an expression or calculation, that NULLs are treated as empty st...
    over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Utilize Curve Fit Result directly in another visualization.

    Consume the data retrieved from “Export Curve Fit Result” directly without the need to export it and re-import it back to the analysis itself.
    over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Separate the StdDev function/aggregation like Excel function

    Hello, This is Nagwon Jeong. I would like to suggest one function/aggregation. In Excel, there are STDEV.P, STDEV.S, STDEVA, and STDEVPA functions to obtain the standard deviation. And the function/aggregation to get the standard deviation in ...
    almost 8 years ago in Spotfire / Custom Expressions 1 Future Consideration

    Use List Document Property in SQL "IN" Statement within Custom Expressions

    It would be useful to be able to pass a list type document property (e.g. "String List", "Date List", etc...) into a SQL "IN" statement in a custom expression or calculated column. This can then be used to provide input for options for consumer us...
    almost 6 years ago in Spotfire / Custom Expressions 3 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.