Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 137

Support date functions in OVER context

We need to summarize data in expression by Month(Date) ... but unfortunatly we currently cannot use MONTH function inside OVER context.
over 8 years ago in Spotfire / Custom Expressions 1 Future Consideration

Create expressions from filter selections

Creating filter expressions for individual visualizations requires manual coding. Would like an option to include current filter selections in an expression so that non-technical business users can easily reduce the dimensions included in the visu...
over 2 years ago in Spotfire / Custom Expressions / Filters 0 Future Consideration

Add visible description for data transformations

When looking at a list of inline transformations, the name/description is the name of the transformation type. I user-provided description would be helpful when reviewing or modifying transformations. Currently, a user needs to open each one just ...
about 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

Mixed dataset calculations

Need to be able to call a user defined function and pass it data from more than 1 dataset. Table lookup with interpolation/extrapolation is very valuable. Need to be able to use values from 1 dataset and lookup/interpolate in another. For Ex table...
almost 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

Time zone conversion function

Currently we have the timezone conversion set up on database side, but if the user wants to change the timezone, then this will restart the pain stacking data import. One can solve it robustly by adding timezone difference with the DateAdd functio...
over 7 years ago in Spotfire / Custom Expressions 1 Future Consideration

Custom Expression Manager

A mechanism is needed to manage and edit all custom expressions at a document level and then by reference not have to repeat them by chart or property control. Currently we employ document properties to manage large or complex expressions, and any...
over 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

Net Present Value (NPV) Function

No description provided
over 2 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add DistinctValueCount, RowCount, ValidRowCount, InvalidRowCount, MinValue, MaxValue, MinNumericValue, MaxNumericValue as column properties

I would like DistinctValueCount, RowCount, ValidRowCount, InvalidRowCount, MinValue, MaxValue, MinNumericValue, MaxNumericValue to be available as column properties. They were available in 5.0 and earlier versions of Spotfire.
about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

Short Format Customization

Make all of the numbers in a column to be shown in the same short format. For example I have a number in the millions but I want it to show as 0.20Bn. I created a Short format saying 10^9 show billions but anything under a billion is showing the f...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Set Default Color For Categories

Frequently, there are specific colors that I want to use for certain dimensions in my data. For instance, if I have credit card transaction data, and I want to break things out by 'Card Type', I should be able to set "AmEx = Green", "Visa = Blue",...
about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration