Functions
Functions work similarly to parameters but are used for mathematical calculations. Functions can be added in conjunction with a parameter. Multiple parameters and functions may also be added to one search. The following functions are available to be added to numeric columns:
1.
Sum
2.
Mean
3.
Count
To add a function, click
Add New Function
below the parameters grid.
Filters | Description |
|---|---|
Columns | Displays all fields within the Display Columns table. |
Function | Displays all available functions (listed above). |
To apply a chosen function to a column, click
Insert
.
The result will display in the
Result
column next to the Function
list.
If a function was chosen to be run against a non-numeric column, an error message will appear:
