REMOVE modifier

Userlevel 3

+2

Description

Returns an object (Metric or Property) with less Dimensions.

source_property[REMOVE AGGREGATOR: dimension1, dimension2, ...]source_metric[REMOVE AGGREGATOR: dimension1, dimension2, ...]

Default aggregator, if omitted, is SUM for number objects. Other aggregators are listed here: Aggregation Methods.

same as source object

Revenue is a number Metric with the following Dimensions: Country, Product and Month

Case	Results
`Revenue[REMOVE SUM: Country]`	Returns the `Revenue` by `Product` and `Month` where all Countries were summed up.
`Revenue[REMOVE AVG: Country, Product]`	Returns the `Revenue` by `Month` with the average value of `Country` and `Product`.
`Revenue[REMOVE MIN: Country, Product, Month]`	Returns the minimum value of `Revenue` across all Dimensions. This is similar to using the MINOF function.
`Employee.Department[REMOVE COUNTBLANK: Employee]`	Returns the number of `Employee` with empty values in the `Employee`'s `Department` Property.