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.