Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 137

Divide a Timespan with an Integer

When working in mobile data, we need to divide Communication time (timespan) with number of Call (Integer). Today the solution provide with conversion are far too complex for users.
about 8 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

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...
about 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...
over 5 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.
almost 3 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...
almost 9 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...
about 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.
almost 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

Differences between Preprocessor ($) and Document Property in custom expression

End user can insert a document property into an expression using the Insert Property option in the calculated column expression. This would add a preprocessor($) expression like ${documentproperty} When renaming a column name, the expression using...
over 3 years ago in Spotfire / Custom Expressions 1 Future Consideration

Custom expression function to format data(numeric/datetime,etc) like String.Format([column], "c# format string")

It's good to have custom expression function to format data like String.Format([column], "c# format string") in custom expression or calculated column. Thanks.
about 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
about 7 years ago in Spotfire / Custom Expressions 0 Future Consideration