Applies to:
| Status | ||||
|---|---|---|---|---|
|
| Status | ||||
|---|---|---|---|---|
|
| Status | ||||
|---|---|---|---|---|
|
Description
Transfer columns in groups to the R server. On each group the R-Script is applied and one result is expected.
Syntax
| Code Block | ||||
|---|---|---|---|---|
| ||||
RAGG(table.column AS input_name(, table.column AS input_name)*, r_script) |
- table.column: Column(s) to be transferred to the R server
- input_name: Name under which the column will be accessible in the R script
- r_script: R script to be called
RAGG is an aggregation. It splits the input in groups and calls for each group the R script. The R script has to aggregate the group and return a single value.
Examples
Execute RAGG to calculate the correlation of the example data from LINEAR_REGRESSION
| Panel | |||||||
|---|---|---|---|---|---|---|---|
| |||||||
Column1
|
In this example the sum of a column is calculated via an R script, executed by RAGG.
| Panel | |||||||
|---|---|---|---|---|---|---|---|
| |||||||
Query
|