Spotfire Ideas Portal
Hello,
We understand that available functions are limited in custom expressions when data is loaded as external.
Our customer would like to have the ability to specify a piece of sql expression like below in custom expressions.
CASE WHEN [column]='Apple' THEN 1 ELSE 0 END
The purpose is to utilize all available functions / expressions provided by the database in order to do some calculation in the database, no matter spotfire has supported it or not. This would greatly improve the usability and flexibility of external data without using custom query.