Stack Overflow
Stack Overflow

Questions tagged [terr]

TERR is shorthand for *TIBCO Enterprise Runtime for R*. It's integrated into recent versions of the Spotfire Professional client and allows running R scripts within Spotfire.

From the Official Spotfire documentation on TERR:

TERR, a key component of Spotfire Predictive Analytics, is an enterprise-grade analytic engine that TIBCO has built from the ground up to be fully compatible with the R language, leveraging our long-time expertise in the closely related S+ analytic engine. This allows customers to continue to develop in open source R, but to then integrate and deploy their R code on a commercially-supported and robust platform—without the need to rewrite their code.

42 questions
6
votes
2 answers

How can I get data tables to be refreshed in Spotfire if I am using a data function to import data from Qualtrics?

I am using the package qualtRics in TERR in Spotfire to pull in data directly from specific surveys in Qualtrics. The code I am using is: registerApiKey(API.TOKEN = "xxxx") df <- getSurvey(surveyID = "xxxx", root_url =…
Jen
  • 69
  • 5
5
votes
1 answer

Creating ellipses based on coordinates and area with R to plot on map

How can I create, using R, ellipse polygons from a dataframe containing x, y, and z, Orientation, and Ratio columns? What R packages and functions could I look at to accomplish this? I would also like to calculate the overlapping area when ellipses…
sean
  • 98
  • 5
3
votes
0 answers

r - In is.not.number.warning(x)

I have a problem to perform a kruskal wallis test with package data.table and module Terr on RStudio. Variables : $WL_TEST_Q1: num[1:41725] $SPLIT: chr[1:41725] $TEST_NUM_NAME: chr[1:41725] Code : setDT(DT) KwTestQ1 <- DT[!is.na(WL_TEST_Q1),…
Laurent Cesaro
  • 341
  • 1
  • 3
  • 17
2
votes
1 answer

Unable to install R packages in spotfire analyst

I'm using Spotfire Analyst v10.4. I'm writing data functions in Spotfire which require specific R packages. I've tried installing packages from TERR console and from TERR package management. I am an admin user and every time I get the same error : …
Shivam Sarin
  • 551
  • 1
  • 7
  • 20
2
votes
1 answer

Execute Postgres Function in R

I am trying to execute a postgres function within R (using Spotfire Terr), however I cant get the syntax to work for dbSendQuery I have tried both dbGetQuery and dbSendQuery and can't get it to work. I looked for several examples, but the only ones…
yanci
  • 163
  • 1
  • 13
2
votes
1 answer

Error When Running Data Function With "Force Server" On Run Location

I'm having a constant error whenever I try to execute my data function forcing it to run on Spotfire Server. The script works fine on R Studio and also on Spotfire if the Run Location configuration is set to "Force Local" or "Default". When I use…
Oliver Drummond
  • 680
  • 1
  • 6
  • 19
2
votes
2 answers

Sourcing one data function within another data function in the same library in Spotfire

I have written two Data Functions in Spotfire as R script Type. One Data Function sources the functions from another Data Function, say "FunctionName.R," in R as: source("C:\\Users\\Username\\FunctionName.R") However, I need to reference the same…
yellowjacket05
  • 149
  • 1
  • 2
  • 12
2
votes
0 answers

Spotfire custom format column / tooltip via IronPython or TERR

I have a visualization that plots from a data table that is being replaced by a TERR function every time a marking is changed. The problem is that my custom formatting for the table columns is lost every time the table is replaced. Basically I…
shwan
  • 538
  • 6
  • 21
2
votes
0 answers

Spotfire Export data table using TERR function

I need to export (to a folder) a few tables I have created within spotfire. The idea is to do it using a TERR function. I would like to export as stdf or sbdf format. The only example I have found is How to…
thundermils
  • 33
  • 7
2
votes
1 answer

"Subscript out of bounds" when running apply() in TERR, but works in plain R

When I try running the following piece of code in Spotfire Professional as a "R Script - Tibco Enterprise Runtime for R": mydata_broken <- structure( list( Var1 = list(3.99083333270391, 3.99083333270391, 3.99083333270391, 3.99083333270391), …
Frank Schmitt
  • 30,195
  • 12
  • 73
  • 107
1
vote
1 answer

Inconsistencies of R scripts between RStudio and TibcoSpotfire

When making data functions for Tibco SpotFire - build version 7.8.1.0.9 - I use RStudio - R version 3.5.2 (2018-12-20) - for writing and debugging the functions, and then I copy my code into SpotFire when I am done. On several occasions, I have…
user3558855
  • 303
  • 4
  • 17
1
vote
0 answers

Dynamic aggregation column input reference in Spotfire TERR data function

How can I make a dropdown menu that allows me to reference different columns and change the column reference of a data function in Spotfire's TERR/R? I am creating 2D cross plots of data, using TERR data function to overlay the average profile line…
sean
  • 98
  • 5
1
vote
0 answers

Date and DateTime in Spotfire 7.x used with sdcGetData function parameters

does anyone know how to use Date / DateTime Spotfire types as parameters for sdcGetData in R? I'm trying to access data in our Spotfire library using the SpotfireData library availble in TERR. I follow the instructions in the documentation here. I…
Josh
  • 2,767
  • 1
  • 27
  • 31
1
vote
1 answer

Trouble with Spotfire R code (TERR) - Invalid subscript type 'list' error

I've written code that runs perfectly in R Studio (3.4.3). I copied the code over into a Spotfire project (TERR) and it ran fine once or twice, but now bombs with the "Invalid subscript type 'list'" error. I have identified it coming from the line…
JDC
  • 23
  • 7
1
vote
2 answers

Use SpotfireData package with non-TERR R engine

I want to read in Spotfire Binary data into a non-TERR R engine that can handle graphing and other complex packages, etc. So I want to use the SpotfireData package with other non-TERR R engines. Yet when I try to install, I get an…
shwan
  • 538
  • 6
  • 21
1
2 3