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.
WHY...
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.
Please upgrade TERR to the latest R version, in order to support latest R packages. Currently the latest TERR version is 6.0.3 which is based on R 4.0.2 which is released in July 2020. There have been lots of newer versions of R since then.
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...
Make all of the numbers in a column to be shown in the same short format. For example I have a number in the millions but I want it to show as 0.20Bn. I created a Short format saying 10^9 show billions but anything under a billion is showing the f...
I would like to see the PAD (and/or LPAD/RPAD) function added to Spotfire. This is a common string function in many other DBMSs and tools. Example use case:I had a data source with one column containing SEQUENCE (i.e. integer 1-15) and another col...
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...
add option to trust PyPI sites for installing python packages to Analyst
Some of our customers are seeing below error when using Python Tools to manage python packages. (possible due to proxy server is enforcing SSL inspection on HTTS communications including PyPI) 2023-07-14T08:55:42,837+09:00 2023-07-13 23:55:42,837 ...
Export R TERR script to R-Studio w/one button click
From Spotfire R / TERR script editor, have a right-click option to export existing script to R-Studio and automatically export the Spotfire Data that is required in the script.
Currently, a user needs to copy the R / TERR from Spotfire, then laun...
Create a Data Function definition (.sfd file) directly from RStudio
WHAT: Provide utility functions, documentation, perhaps UI for an R author to create a Data Function Definition directly from RStudio
WHY: Enable an R author to create Data Functions without having to use the Spotfire UI, and do more of their work...