Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4428

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...
over 6 years ago in Spotfire / Custom Expressions 1 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"...
about 2 years ago in Spotfire / Custom Expressions 0 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 ...
about 9 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...
about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

add function to convert integer to ascii character and vice versa

Please add function to convert integer to ascii character and vice versa. Currently we use expression like below to do so, it's ugly & slow and can not cover all ascii chars. case when ([val]>=48) and ([val]<=57) then string([val] - 48) ...
over 2 years ago in Spotfire / Custom Expressions 1 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...
almost 5 years ago in Spotfire / Custom Expressions 2 Already exists

Exclude Columns Transformation: Honor Exclusions Even When Data Type Changes

I want the exclude columns transformation to honor my request when I exclude column(s). I do not care if the data type changes. If I want the column excluded, then I do not want it in my data tables -- unless I specifically allow it. At the moment...
over 2 years ago in Spotfire / Custom Expressions / User Experience 0 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.
over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

IFERROR Function

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