Functions in Opportunity Detect
Functions perform some additional processing on a record set returned by a Container or Select component. Functions allow you to apply commonly used database functions to the records.
Functions are available in the following component types.
- Container
- Select
- In the Value Selector in a component that allows a Container or Select component as a data source.
Function definitions
The following table describes how functions work.
Function | Description |
---|---|
Average | Use an average of the values in the field. |
Count | Counts the number of times this field occurs in the record set. Returns an integer. |
Count Distinct | Counts the number of times this field occurs in the record set, excluding fields with duplicate values. Returns an integer. |
First | Use the value with the oldest timestamp. |
Group By | In Select components, groups together all the records that have identical values in this field. Returns one or more groups of rows. The Group By function can be applied to only a single field in a component. |
IsMemberOf | Compares a single value with a single field in each row contained in a Select component. See the expanded explanation elsewhere in this chapter. |
Last | Use the value with the most recent timestamp. |
Maximum | Use the highest value in the field. Returns an integer. |
Minimum | Use the lowest value in the field. |
Mode | Use the value of the most frequently occurring value in this field. When a tie situation exists, an age factor is used; the oldest value is returned in this case. |
Sum | Use the total of the values in the field. |
Standard Deviation | Measures how much variation or dispersion from the average exists in the values of this set of fields, using the STDEVP formula. Returns an integer. |