REMOVE modifier

  • 21 December 2021
  • 0 replies
  • 287 views

Userlevel 3
Badge +2
  • Community Manager
  • 8 replies

 

Description

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

 

Syntax

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.

 

Return type

same as source object

 

Examples

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.

 


Excel equivalent: none

See also: ADD, FILTER

 

 


0 replies

Be the first to reply!

Reply