Function measuredValue

measuredValue( measure, filters, name?, format?): CalculatedMeasure

Creates a measured value with the given measure and set of filters.

A measured value only includes values from items that match the provided filters.

For example you can use a measured value to get a total cost for all items where the cost is greater than 100.

Note that the filters on the measured value override the filters on the query, chart, or table the measured value is used in.

Parameters

Parameter	Type	Description
measure	Measure	Measure to filter
filters	Filter[]	Filters to apply to the measure
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

CalculatedMeasure

A calculated measure instance

Example

Calculate the total cost across all items in a category from the Sample Ecommerce data model, where the cost is greater than 100. Additional filtering on the cost will not affect this measure.

measureFactory.measuredValue(
  measureFactory.sum(DM.Commerce.Cost),
  [filterFactory.greaterThan(DM.Commerce.Cost, 100)],
  'Cost Greater Than 100'
),