Custom Expressions

Showing 139

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

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

7 VOTE

Separate the StdDev function/aggregation like Excel function

Hello, This is Nagwon Jeong. I would like to suggest one function/aggregation. In Excel, there are STDEV.P, STDEV.S, STDEVA, and STDEVPA functions to obtain the standard deviation. And the function/aggregation to get the standard deviation in ...

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

2 VOTE

Allow axis in a visualization to be used as a part of an OVER expression regardless of axis type

Currently, an axis has to be of type Categorical for it to be available in an Custom Expression with OVER() - e.g., [Axis.X] - in a given visualization. However, to add Line and Curves in the same visualization, the axis has to be Continuous. Enab...

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

5 VOTE

Use List Document Property in SQL "IN" Statement within Custom Expressions

It would be useful to be able to pass a list type document property (e.g. "String List", "Date List", etc...) into a SQL "IN" statement in a custom expression or calculated column. This can then be used to provide input for options for consumer us...

over 5 years ago in Spotfire / Custom Expressions 3 Future Consideration

7 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

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

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

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

8 VOTE

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

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

5 VOTE

Custom Expressions - formula in-line context

Add functionality like found in other coding languages (R, SQL, even Excel) which would show preview text when creating a new custom expression. For example: When you start typing... dateadd( you would see something like... dateadd( 'increment'...

about 6 years 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...

over 2 years ago in Spotfire / Custom Expressions 2 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.

over 9 years ago in Spotfire / Custom Expressions 1 Future Consideration

Please enter your email address

FILTER BY CATEGORY