Custom Expressions

Showing 144

Filter data by expression prior to pivoting

Currently, creating a pivot table requires the entire source table to be used for the pivot when I frequently would only like a specific subset of data to be pivoted. An option to use a custom expression to filter the data prior to pivoting would ...

about 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

6 VOTE

Orthogonal Distance Regression (ODR)

Hi We would like to see the orthogonal regression as an additional comparison method under Tools-->Data Relationships to add this type of regression to the data relationship tool

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

6 VOTE

Add a Random Function

Hello We need a real random function, that would create a random integer number for each line of our data table. Every time the user would open a DXP file, the random generated would be different. We tried with Rand(count()), but the numbers gener...

over 6 years ago in Spotfire / Custom Expressions / Data Management 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 4 years ago in Spotfire / Custom Expressions 0 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 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

7 VOTE

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.

almost 8 years ago in Spotfire / Custom Expressions 1 Future Consideration

6 VOTE

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

almost 7 years ago in Spotfire / Custom Expressions 1 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 8 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 5 years ago in Spotfire / Custom Expressions 0 Will not implement

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

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

Please enter your email address

FILTER BY CATEGORY