Need to be able to call a user defined function and pass it data from more than 1 dataset. Table lookup with interpolation/extrapolation is very valuable. Need to be able to use values from 1 dataset and lookup/interpolate in another. For Ex table...
Currently the way data is passed to the TERR engine from Spotfire is through a file saved to disk and then read by TERR.
This is very time-consuming and inefficient when using millions of rows with many columns.
For TERR to be useful in this case ...
Surface Python warnings without having to enable debugging
I think it would be very helpful for developing data functions if we could surface warnings without involving the debugging feature. Sometimes for instance there is a call to an API and that call may fail; one way of designing the code would be to...
Currently we have the timezone conversion set up on database side, but if the user wants to change the timezone, then this will restart the pain stacking data import. One can solve it robustly by adding timezone difference with the DateAdd functio...
Easily display htmlwidgets/Javascript visualizations from TERR in Spotfire
WHAT: TERR can create interactive visualizations using htmlwidgets based (and other) Javascript visualizations, but there is not an easy way to return those to display in Spotfire. There should be a simple and straightfoward way of doing this.
WH...
Change the DateDiff function so that it returns int instead or real and doesn't return factional numbers
Currently, the DateDiff function factors in the fraction of the whole when returning the differences between year, quarter, month, etc. This can be confusing and hard to use when trying to calculate the differences between months as it will return...
I would like DistinctValueCount, RowCount, ValidRowCount, InvalidRowCount, MinValue, MaxValue, MinNumericValue, MaxNumericValue to be available as column properties. They were available in 5.0 and earlier versions of Spotfire.
One of the requests that I receive most from users who are R and Python programmers, is the request that within Spotfire they could create graphics using the open source language packages. I know that currently the TERR engine does not provide gra...