Weighted Average Tool
Use Weighted Average to calculate the weighted average of an incoming data field. A weighted average is similar to a common average, but instead of all records contributing equally to the average, the idea of weight means some records contribute more than others.
Configure the Tool
- Value Field (Numeric): Use the dropdown to select the numeric field that contains the data to return the Weighted Average on.
- Weight Field (Numeric): Use the dropdown list to select the numeric field that contains the weight to calculate the weighted average of. When all records have the same weight the returned value is a common average.
- Output Field Name: Enter the desired output field name for the calculated Weighted Average.
- Grouping Fields (Optional): This is an optional setting. You can elect to specify a grouping field and the weighted average will be calculated for each group of values in the data stream.