# 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

BaseMeasure

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)