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