| Table of Contents | ||||
|---|---|---|---|---|
|
...
After grouping the data, select Aggregate in the search window toolbar, then select the Collect compact operation. You need to specify one argument:
Argument | Data type |
|---|---|
mandatory | any |
The data type of the aggregated values is map.
...
The arguments needed for the collect distinct compact operation are:
collect compact → responseLength field
...
Then, use select... as... to add the new field that will show the aggregated values. This is the syntax for the collect distinctcompact operation:
| Code Block |
|---|
collectcompact(numeric_field) |
...