frequency() Function

Function

frequency( data_array, bins_array )

Uses the bin array to create groups bounded by the elements of the array.

Parameters

Keyword	Type	Description
data_array	Decimal Array	The set of numbers that will be divided into groups according to bins_array and then counted
bins_array	Decimal Array	The upper (and inclusive) boundaries of the groups into which the elements from the data array will be dispersed.

Returns

Integer Array

Usage considerations

Using the bins_array parameter

The bins_array argument also defines one additional group capturing all numbers greater than the maximum number in bins_array.

Understanding results

The return value represents how many elements from the data array fall into each of these groups.

Examples

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 compatibility

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

Feedback