Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4796

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 ...
almost 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...
almost 10 years ago in Spotfire / Custom Expressions 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.
about 8 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 8 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 5 years ago in Spotfire / Custom Expressions 2 Already exists

Add ability to reference already created values that are defined in a custom expression

Being able to reference already created values that are defined in a custom expression. For example you might use the below custom expression code. I will create an average voltage and standard deviation voltage variables for my typical process. I...
almost 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

Allow OVER functions to access multiple aggregations and allow multiple OVERs per Custom Expression

Currently the OVER function is, frankly pretty poorly implemented for anyone wanting to do data analysis that's not time series data. OVER functions should be able to access aggregations in parenthesis. For example, if I wanted to calculate the av...
almost 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

calculate over all periods of detail levels

Lets say we have a hierarchy of Year.Month, we want to calculate sum on all the same months (e.g. March) of each year. ParallelPeriod() can only calculate on the same month of previous year.
almost 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

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