sisense.com
✅ You are viewing documentation for the latest version of Compose SDK.
Version:

Function avg

avg( attribute, name?, format?): BaseMeasure

Creates an average aggregation measure over the given attribute.

Both average() and avg() can be used interchangeably.

Note: Only numeric attributes are supported.

Parameters

ParameterTypeDescription
attributeAttributeAttribute to aggregate
name?stringOptional name for the new measure
format?stringOptional 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)
Last Updated: