Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 144 of 4253

'Excel like' custom expression: floating short description that will select the whole element on click

Hello, In Excel, when a formula is being edited a floating menu appears. This is something like '=sum(numer1;[number2])'. I am more interested in the functionality of this since the description is very easily found. It may not sound as much but ...
about 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

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

Add YearAndMonth and Trunc Funtion

I need a year/month combination constantly for calculations like "get data between two months ago 1st of the month to the end of next month" Having either or both of these functions would make this task much easier. Yes, I can accomplish both toda...
about 6 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

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

Self joins to calculate changes

Hi, I need help with this in Tibco Spotfire 7.6 I have columns [Name] [Manager] [Director] [Date] Rahul Rohit Ravi Jan-18 John Jessica Parul Jan-18 Tj Manu Raghav Feb-18 Rahul Rohit Rashid Feb-18 John Jessica Parul Feb-18 I want to dis...
over 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

$esc() should also take strings as argument

Sometimes it would be useful when $esc() could use a string argument instead of a property. For example to set a display name using a condition, something like the foloowing expression: [Column] as $esc(if(${property}="1","1","not 1"))
over 6 years ago in Spotfire / Custom Expressions 0 Will not implement

Enable text funtions for custom expressions

I am having a filter that has a long name. E.g. 'Performance Yaw'. This is to distinguish for the users between 2 types of analysis, e.g. Performance or Reliability. Now I am trying to use it in a custom expression where I want to use always the...
over 6 years ago in Spotfire / Custom Expressions 1 Future Consideration

Cross table formatting of Timespan

In cross table a column that is formatted as h:m:s gives the correct grand total. However the same column if formatted as hh:mm:ss, the behavior changes and Spotfire resets the hours to 0 after every 24 hours and gives a different grand total. Exa...
over 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

allow to view and select unique data values of selected column when writing expression.

sometimes, when we are writing an expression, we used the values of the column so if it can be autocompleted or displayed unique values and let the user copy it, it will be very useful. for example: [Country] != "Egypt", if I select column [coun...
over 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add a "Proper" function

The upper and lower functions are very useful. It would be helpful to also have a "proper" function similar to what is done within Excel to convert the first character of each word to upper case and all other characters to lower case.
over 6 years ago in Spotfire / Custom Expressions 0 Future Consideration