Custom Expressions

please add logical function any() / all()

please add logical function any() / all() to calculate any(true,false,false) => true any(fale,false,false) => false all(true,true,true) => true all(true,true,false) => false Currently we can sum them and compare to the count to do the ...

over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

2 VOTE

Add an aggregation method to find the Nth most common value

MostCommon is a pretty useful aggregation method, for example when you have a large set of defective parts across different products and these are defective for different reasons and you want to see the most prominent error say per product. Very e...

almost 3 years ago in Spotfire / Custom Expressions 2 Future Consideration

5 VOTE

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 ...

over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

7 VOTE

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.

over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

5 VOTE

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

4 VOTE

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...

over 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

3 VOTE

web client support for statistical tools

It would be useful to be able to invoke the Spotfire Statistical tools from the Web Client. This would allow creating new Classification and Regression Models as well as using Line similarity and Clustering.

almost 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

6 VOTE

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

4 VOTE

Change the DateDiff function so that it returns int instead or real and doesn't return factional numbers

Currently, the DateDiff function factors in the fraction of the whole when returning the differences between year, quarter, month, etc. This can be confusing and hard to use when trying to calculate the differences between months as it will return...

almost 7 years ago in Spotfire / Custom Expressions 0 Will not implement

6 VOTE

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",...

over 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY