Description
Adds one or multiple Dimensions to a Block.
It will then distribute the data across those dimensions depending on the defined allocation method.
Syntax
Adding one dimension
input_blockkADD: dimension]
Adding one dimension with allocation method
input_blockcADD Allocation method: dimension]
Adding more than one dimension and allocation method
input_blockoADD Allocation method: dimension1, dimension2, ...]
Return type
same as source object
Allocation Methods
Constant - this method will take the value from the source metric or property and apply it to every item within the newly added dimensions. This is the default behavior if no allocation method is defined.
input_blockuADD Constant: dimension]
Split - this method will take the value from the source metric or property and distribute it evenly across the items within the newly added dimensions.
input_blocknADD split: dimension]
Example
Source Metric Country is a simple metric with one dimension, Country. In this example, the Month dimension is added first, then you can see a custom allocation method of SPLIT is defined.
Excel equivalent: none
See also: REMOVE
For detailed insights and video discussions on typical use cases and common pitfalls of the ADD modifier by a Pigment Solution Architect, explore the ADD & REMOVE Modifier module in the Academy.