Output Selector: Average

1.3.3.10.1 Output Selector: Average

The Average output selector calculates and outputs the average of all Number values input to it from all the records being merged together.

The Average selector is often used for reporting on data, where records are grouped together by a common attribute value (or attribute values), or matched together using complex rules.

For example, you might use Group and Merge to group a number of order records by product identifier, and calculate and output the average order value for orders for each product.

The following table describes the configuration options:

Configuration Description

Configuration	Description
Inputs	Any Number attributes from any input data sets.
Options	Specify the following options: `Consider Nulls as 0?`: drives whether to consider Null values in the Number attribute as 0 values in the Average calculation, or whether to disregard them. Type: Yes/No. Default value: No. Yes, means Null values are treated as 0.No, means Null values are disregarded.

Inputs

Any Number attributes from any input data sets.

Options

Specify the following options:

Consider Nulls as 0?: drives whether to consider Null values in the Number attribute as 0 values in the Average calculation, or whether to disregard them. Type: Yes/No. Default value: No.

Yes, means Null values are treated as 0.No, means Null values are disregarded.

Example

In this example, the Average output selector is used to select the Average for an OrderValue (Number) attribute from each record.

Example configuration

Consider nulls as zero? = No

Example output

The following table shows examples of output selection using the Average selector:

Table 1-100 Example of Output Selection for Average

Record A	Record B	Output value (Average)
1089.78	598.65	844.215
176.99	168.34	172.665
63.99	32.99	48.49
543.99	543.99	543.99
null	5	5
null	null	null