Banding

Maps metric values that fall within a certain range to a particular integer band value. The range and band values are determined by the parameter input to the function. For example, if 5,000 is the specified range, the dollar sales are shown in bands of 0 - 5,000, 5,001 - 10,000, 10,001 - 15,000, and so on. This is a single-value function.

Syntax

Banding <HasResidue>(Argument, StartAt, StopAt, Size)

•  

• Argument is a metric.

• Size is a real number indicating the width of each band.

• StartAt and StopAt are real numbers specifying the full range of the values to be placed in bands.

• HasResidue is a TRUE/FALSE parameter that defines whether an extra band is created for all values that do not fall within the StartAt and StopAt values. Defining HasResidue as True allows the function to create an additional band which is used to identify all values outside of the defined band range.

For additional information on this function, refer to the MicroStrategy Functions Reference.