MicroStrategy ONE

Banding type: Metric value banding

The Band for each distinct metric value type of banding qualification creates a separate band for each value calculated by the metric. The bands appear as rows on a report. This type of banding qualification directly uses the results of a metric as bands. It is very useful with metrics that already contain the logic needed to calculate sequential band numbers. Such metrics use mathematical formulas, NTile functions, Band functions, or Case functions.

For example, a metric uses the NTile function to group revenue values into three groups. The custom group element is therefore sliced into three bands as well.

For instructions, see Creating custom group banding qualifications.

For more information and an expanded example, see the Custom Groups and Consolidations chapter in the Advanced Reporting Help.