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 |
| Returns the |
| Returns the |
| Returns the minimum value of |
| Returns the number of |
Excel equivalent: none
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!
