BandingP

Returns metric data grouped into bands identified by user-specified boundary point values (for example, 0 - 5000, 5000 - 20,000, 20,000 - 30,000). Assigns integer values to the resulting metric. This function allows you to create intervals of varying widths. This is a single-value function.

Syntax

BandingP <HasResidue>(Argument, Boundary1, Boundary2, Boundary3...Boundaryn)

•  

• Argument is a metric.

• Boundary1 through Boundaryn are real numbers indicating the cut-off value for each band. Boundary1 is less than Boundary2, Boundary2 is less than Boundary3 and so on.

• HasResidue is a TRUE/FALSE parameter that defines whether an extra band is created for all values that do not fall within the Boundary1 and Boundaryn 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.