FunctionCopy link to clipboard
frequency( data_array, bins_array )
Uses the bin array to create groups bounded by the elements of the array.
ParametersCopy link to clipboard
| Keyword | Type | Description |
|---|---|---|
|
|
Decimal Array |
The set of numbers that will be divided into groups according to bins_array and then counted |
|
|
Decimal Array |
The upper (and inclusive) boundaries of the groups into which the elements from the data array will be dispersed. |
ReturnsCopy link to clipboard
Integer Array
Usage considerationsCopy link to clipboard
Using the bins_array parameterCopy link to clipboard
The bins_array argument also defines one additional group capturing all numbers greater than the maximum number in bins_array.
Understanding resultsCopy link to clipboard
The return value represents how many elements from the data array fall into each of these groups.
ExamplesCopy link to clipboard
For example, a bin array equal to {70, 79, 89} defines four groups:
- numbers where number <= 70
- numbers where 70 < number <= 79
- numbers where 79 < number <=89
- numbers > 89
frequency({64,74,75,84,85,86,95},{70,79,89}) returns 1*2*3*1
Feature compatibilityCopy link to clipboard
The table below lists this function's compatibility with various features in Appian.
| Feature | Compatibility | Note |
|---|---|---|
| Portals | Compatible | |
| Offline Mobile | Compatible | |
| Sync-Time Custom Record Fields | Compatible | Can be used to create a custom record field that only evaluates at sync time. |
| Real-Time Custom Record Fields | Incompatible | Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. |
| Process Reports | Compatible | |
| Process Events | Compatible | |
| Process Autoscaling | Compatible |