Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 139

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 8 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 8 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 4 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 8 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...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Create new "Tall" data table when using One-Click Unpivot

The One-Click Unpivot feature transforms data from the "wide" to the "tall" format. When it does so, it transforms the existing data table. On occasion, it is helpful to have both the original wide format as well as the new tall format. My request...
over 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

Can you please add SIGN function to the math functions?

No description provided
almost 5 years ago in Spotfire / Custom Expressions 1 Future Consideration

Use expression spanning two tables with over expression for the main table.

1. Open SuperstoreSales 2. Add Data Tables -> SuperstoreSales again, call it T2. 3. Insert a barchart, use <[Order Priority]> on the x-axis 4. On the y-axis write: Sum([Sales Total]) OVER (AllPrevious([Axis.X])) - Sum([T2].[Sales Total]) ...
almost 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

Data functions should consider visual properties

Trellis by panel operation on data function execution results shows incorrect data in all split panels.This is an enhancement to support Data functions to any visual properties
almost 10 years ago in Spotfire / Analytics / Custom Expressions / Data Functions 0 Future Consideration

Expression Function in calculated column or in custom expression should work without any parameter value

Expression Function in calculated column or in custom expression always requires at least single parameter value to be passed. Steps to reproduce: - From Spotfire 7.0 Beta release , define new expression function(via the 'Data Function properties'...
almost 10 years ago in Spotfire / Analytics / Custom Expressions 2 Future Consideration