Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

    For String columns in Data Panel, show counts for each unique category value

    For number columns in data panel, a histogram is shown to visualize the data distribution. We also need a similar way to visualize the distribution of data for string columns. The way to do this is to visualize the counts for each unique category ...
    over 10 years ago in Spotfire / Custom Expressions 1 Future Consideration

    Select All/Deselect all options in Hierarchical Filter

    "Hierarchy query devices by default use checkboxes. It would be very helpful to add Select All and Deselect all options for the checkboxes at each level of the hierarchy. For large hierarchies e.g. 3 levels of 10 nodes, it is quiet time consuming ...
    over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Filters should interact with each other even when data is external

    Filters to influence eachother, and grey out filtered out values for other columns when filtering on any column, as it works when working with imported data. As a consumer and report developer I want the filters to behave the same when working wit...
    over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

    display of common mathematical expressions based on highlighted data

    Would like to highlight data on a graph, and have Spotfire tell me things like the Average, Mean, Max, Min without having to code. I should be able to Display or Hide the "Stats" window, and based on what I highlight in the graph, it calculates th...
    about 8 years ago in Spotfire / Custom Expressions 1 Future Consideration

    Custom expression function to format data(numeric/datetime,etc) like String.Format([column], "c# format string")

    It's good to have custom expression function to format data like String.Format([column], "c# format string") in custom expression or calculated column. Thanks.
    almost 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Built in conversion for Date strings in serial format

    There doesn't seem to be any way for Spotfire to take a date string in serial format (41397) and convert it into a working date. I know when the data table is being uploaded, it can be registered as a date and will be converted. For the purpose of...
    about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Better decimal point accuracy on color rule for column created through a custom expression

    I have created a percentage value as part of a custom expression - and within the Formatting menu, this field has been setup as a "Percentage". When I create a new color rule using this column, it allows me to enter decimal based values into the r...
    over 6 years ago in Spotfire / Custom Expressions 2 Already exists

    Show available functions for an In-Database Connection to SAP HANA

    Functions like Case, If, All, AllPrevious Over etc. all work in Spotfire for in-database connection to SAP HANA. But they are not shown in the list of functions available. Our users need an easy to use interface without getting into details of wha...
    over 9 years ago in Spotfire / Custom Expressions 2 Future Consideration

    Refer to Marked items in a custom expression

    The should be a way to refer to marked items in a custom expression. for example: sum(if([field1] in marking, 1, 0)) as [var1], sum(if([field1] not in marking, 1, 0)) as [var2] where marking is selected in a different visualization. I know that I ...
    over 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

    Empty values changed to zero in cross table should be used in over calculation

    In version 7.7 it is possible to change empty "---" values to 0 or some other value. When using over statement in cross table this values are not taken into account in calculation. For example, you would like to calculate the difference in sales b...
    almost 10 years ago in Spotfire / Custom Expressions / Visualization 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.