Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4424

Select data table from custom expression dialogue

When using multiple data tables and trying custom expression there is no way to manually select the data table from which to select the column. You can change the data table that is shown on the custom expression menu by going to Edit>Data tabl...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Date Math Functions supported for In Database Connections

Most modern databases (sql server, oracle, teradata, cloudera, etc) support some level of date manipulation functions like dateadd(), add_months(), datediff(), getdate(), etc. Currently Spotfire doesn't support any of these functions across the ma...
almost 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

As a report developer I would like to be able to add rows from an information link so that I can create analysis files for different users

*Description:*As a report developer I would like to be able to add rows from an information link so that I can create analysis files for different users This customer is sending embedded data files to different customers on a regular basis and wan...
about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

Allowing for DateTimeNow() for UTC expression

Having analysts working in different time zones, it would be helpful to have an easier way to link data from different time zones and to use UTC when analyzing the data.
about 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

Expression Editor Enhancements - Hover-over information for functions

Multiple teams in our organization struggle with using the expression editor. One enhancement that gets mentioned is some kind of hover-over, context sensitive help when editing expressions. For example, hovering over a function name for >2 sec...
over 3 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 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

Fix reaction of Sn() to (Empty) values

There are some (Empty) values resulting from joins e,g, within Graphical table to which SN() does not apply. See this thread https://community.tibco.com/questions/empty-value-does-not-react-sn
over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used

DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used is not available when Keep data external option is selected in connector. This limits the usage of Spotfire.
over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add support for quick calculations to Count/Unique e.g. cumulative sum based on count, difference based on counts

If you are working with a String column e.g. Product Name and you are looking at a unique count of product name by time, you can easily see how many unique products were sold e.g. per month. However, if you want to look at the cumulative unique pr...
almost 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Can you please add SIGN function to the math functions?

No description provided
about 4 years ago in Spotfire / Custom Expressions 1 Future Consideration