# Function avg
avg(
attribute
,name
?,format
?):BaseMeasure
Creates an average aggregation measure over the given attribute.
Both average()
and avg()
can be used interchangeably.
# Parameters
Parameter | Type | Description |
---|---|---|
attribute | Attribute | Attribute to aggregate |
name ? | string | Optional name for the new measure |
format ? | string | Optional numeric formatting to apply using a Numeral.js format string. Can only be used for explicit queries. Cannot be used in charts, tables, etc. |
# Returns
A measure instance
# Example
Calculate the average cost across all items in a category from the Sample Ecommerce data model.
measureFactory.avg(DM.Commerce.Cost)