Custom Expressions

Showing 143

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...

about 3 years ago in Spotfire / Custom Expressions 1 Future Consideration

2 VOTE

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

1 VOTE

Can you please add SIGN function to the math functions?

No description provided

over 3 years ago in Spotfire / Custom Expressions 1 Future Consideration

2 VOTE

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.

over 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

2 VOTE

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

2 VOTE

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.

almost 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

2 VOTE

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...

about 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

2 VOTE

Empty values changed to zero in cross table should be used in over calculation

In version 7.7 it is possible to change empty "---" values to 0 or some other value. When using over statement in cross table this values are not taken into account in calculation. For example, you would like to calculate the difference in sales b...

over 7 years ago in Spotfire / Custom Expressions / Visualization 0 Future Consideration

2 VOTE

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...

almost 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

2 VOTE

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]) ...

over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY