Add Financial Calculations and Optimization OOTB in Spotfire
It would be useful to have basic financial calculations, such as Individual Rate of Return (IRR) and Net Present Value (NPV) in Spotfire, especially for users who are familiar with them from other products such as Excel. Similarly, basic scenario ...
Allow for dropdowns or fixed options in data function flyout
When configuring or registering a data function, I'd like to be able to enforce fixed choices for those input parameters. When running the function in a dashboard with document properties you are able to set options, however when you are running f...
Additional string function where you are able to change the rounding settings
Belongs to the article https://community.tibco.com/questions/rounding-issue-string-function.
If you use a numeric column and convert the result to a string column, there are always only 2 decimals shown. For calculating P values you´ll need 4 dec...
Enable Spotfire expression language for in-database connections
When working with external data one cannot use the standard Spotfire expressions but has to change to the dialect of the given data source (e.g. when working with an Impala connection a Left([Column_A],1) for imported data has to be changed to Sub...
While TERR supports the creation of graphics via Javascript packages (like those based on htmlwidgets), it does not currently support R-style graphics (e.g., the plot function)
please add logical function any() / all() to calculate any(true,false,false) => true any(fale,false,false) => false all(true,true,true) => true all(true,true,false) => false Currently we can sum them and compare to the count to do the ...
Add "Limit data using expression" functionality to data function input data
When specifying input data for a data function, I am missing the "Limit data using expression" function. The limit by filtering and/or marking is there - but not the expression? This would really help limit the number of records sent to R for proc...
Custom data functions should have same UI components (menu items) as custom data sources
The recommendation from TIBCO support is to switch using custom data sources to custom data functions. Support provided the following link to show how this can be done: https://community.tibco.com/wiki/wrap-data-source-inside-data-function The mai...
Ensure `data.table::patterns()` compatibility in future release
data.table is preferred when working with large data sets for speed, and data.table::patterns() facilitates column(s) selection with regular expression, which is useful for concise code, as oppose to doing this as a separate line item.