Function average
average(
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.average(DM.Commerce.Cost)