REMOVE modifier

  • 21 December 2021
  • 0 replies
  • 2973 views

Userlevel 5
Badge +6
  • Community Manager
  • 20 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.

 

🎓 For detailed insights and video discussions on typical use cases and common pitfalls of the REMOVE modifier by a Pigment Solution Architect, explore the ADD & REMOVE Modifier module in the Academy.


This topic has been closed for comments