<< Click to Display Table of Contents >> Current:  Create Dashboard > Table > Visual Analysis > Aggregate Calculation  Weighted Average

The weighted average is the number of values multiplied by the corresponding number of units, then summed to get the total value, and then divided by the total number of units. The user can modify the aggregation mode in the aggregation dialog box to be a weighted average. When the weighted average is selected, the "and" option becomes optional and is mandatory.

➢Example

Bind 2 columns "market" and "sales" to the table component, set the aggregation mode of "sales" to weighted average, and "and" select "area_code". The result is shown below.