July 13, 2017
In a calculated column, is there a way to combine OVER with a custom TERR function?
Yes. In Spotfire 7.7 and later, the family of TERRAggregation_*() functions can be used to combine calls to TERR functions with the OVER structure, as in the following example:
TERRAggregation_Real("output <- max(diff(sort(input1)))",[Mileage]) OVER ([Type])
The above example is demonstrated in the Spotfire analysis in the attached file. (Filename: FuelFrame--TERRAggregate calc column.dxp). It creates the [MaxDiffSortMileageOverType] calculated column in the file's "FuelFrame" data table.
These are the functions in the TERRAggregation_*() family of functions:
Each function's name includes the Spotfire data type of the result it returns.
The dialog that is opened by selecting “Insert > Calculated Column…” from the Spotfire 7.7 desktop client’s main menu provides the following brief introduction to these TERRAggregation_*() functions, along with examples of the syntax used in calling them.
Calls the TIBCO Enterprise Runtime for R engine and returns an output of the specified data type. The first argument is a script and the following arguments are the arguments to the script.
The script should return a single aggregated value. At least one argument other than the script is required.
The inputs will be placed in variables called input1, input2, ... inputN, and the output must be placed in a variable called output.
TERRAggregation_Real("output <- median(input1) + median(input2)", [X], [Y])
TERRAggregation_String("output <- input1", [Customer Name])