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.
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. |
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. |