TERRAggregation_Integer
In the Spotfire
Custom Expressions dialog box, you can select the pre-defined expression
TERRAggregation_Integer
from the
Function list. This expression function sets the variable
output
to a scalar value of the TERR data type
integer
, which Spotfire converts to the corresponding Spotfire data type Integer.
The TERR script is called once for each group of data to be aggregated. No special handling for aggregation is necessary in your TERR script.
Argument | Argument description |
---|---|
A TERR script. | The TERR script contains the following.
|
Spotfire column names. | Passed as additional arguments, these are the data column names that
input1 to
inputN represent. All columns must be the same length.
|
Returned by TERR | Converted in Spotfire |
---|---|
A single aggregated value of data type
integer .
|
A single aggregated value of data type Integer. |
TERRAggregation_Integer example
You can work through the example in
Aggregating binned weather data using TERR in Spotfire, substituting
TERRAggregation_Integer
for
TERRAggregation_Real
. Make sure your inputs are integers, and that you wrap the expression in the
TERR function
as.integer
to make sure the output data type is correct.
TERRAggregation_Integer("output <- as.integer(mean(input1))", [Y])
The resulting table in Spotfire shows the following.
max
, and Spotfire contains the function
Max
. ) You must overwrite this autocorrection manually to ensure that you use the TERR function case and name in your expression function.
See Embedding the contents of a script in an expression function for a detailed procedure for creating an expression function.