BandingC

Returns metric data grouped into a specified number of bands and assigns integer values to the resulting bands (for example, a total of 25,000 in dollar sales shown in five equal bands.). This is a single-value function.

Syntax

BandingC <HasResidue>(Argument, StartAt, StopAt, BandCount)

•  

• Argument is a metric.

• BandCount is a positive integer indicating the number of bands into which the total is divided.

• 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.