Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4379

Enable Insert Binned Column for In-Database

Binning is a very useful feature for dashboarding and also for ad hoc analysis and data discovery to add new categorization criteria. But currently Insert Binned Column dialog is not available for in-database connections. Instead users could use C...
over 6 years ago in Spotfire / Custom Expressions 2 Future Consideration

display of common mathematical expressions based on highlighted data

Would like to highlight data on a graph, and have Spotfire tell me things like the Average, Mean, Max, Min without having to code. I should be able to Display or Hide the "Stats" window, and based on what I highlight in the graph, it calculates th...
over 6 years ago in Spotfire / Custom Expressions 1 Future Consideration

'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 by...
over 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
over 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...
almost 7 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 gener...
almost 7 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 display only ...
almost 7 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"))
almost 7 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 ...
almost 7 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...
about 7 years ago in Spotfire / Custom Expressions 0 Future Consideration