avg( )
Refines a WixDataAggregate
to only contain the average value from each aggregation group.
The avg()
function refines a WixDataAggregate
to contain the average
value from the specified property for each aggregated group or from the
whole collection if no group is defined.
When the aggregation is run, the returned WixDataAggregateResult
object contains an item for each group with the following key:value pairs:
- If a value was passed for the optional
projectedName
, the key is named using that value. Otherwise, the key is named using the following format:"propertyNameAvg"
, wherepropertyName
is the name of the specified property. - The value is the average of the values found in the specified property.
Averages can only be calculated on properties of type Number.
Note: Aggregations can only be used on collections you have created. They cannot be used on Wix App Collections.
Method Declaration
Copy
Method Parameters
propertyNamestringRequired
The property in which to find the average value.
projectedNamestring
The name of the property in the aggregation results containing the average value.
Was this helpful?
Yes
No