REMOVE modifier

  • 21 December 2021
  • 0 replies
  • 1693 views
Ben
Rank
Userlevel 4
Badge +2
  • Ben Community Manager
  • Community Manager
  • 19 replies

Description

Removes one or multiple Dimensions from a Block.

 

Syntax

source_block[REMOVE [aggregator]: dimension1[, dimension2]]

  • source_block This is Metric or List Property that is number or integer formatted, that you want to remove dimensions from.
  • aggregator-  This is an optional argument where you define the aggregation methodology, the default is SUM. 
  • dimension1- This is the dimension that you wish to remove.
  • dimension2- This argument is for any additional dimensions you would like to use, any additional dimensions after 1 are separated by a comma. 

 

The 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

More of a hands-on learner? 

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!

 

 

This topic has been closed for comments

Ask your question here!

Terms & ConditionsCookie settings