MicroStrategy ONE

About custom group elements

A custom group is made up of an ordered collection of components called custom group elements. Each element contains a set of filtering or banding qualifications. Qualifications are the actual conditions that must be met for data to be included in the custom group element. Examples include "Region = Northeast" or "Revenue > $1 million". Each set of qualifications resolves into a list of attribute elements after the report is run. Banding qualifications slice data into ranges based on metric values, such as the top 25 and bottom 25 stores in terms of revenue.

A custom group element contains:

  • A header. This name can be displayed on the report. You can edit the header name, set whether to display it on reports, and choose its location on the report.

  • At least one qualification. You can define any qualification, including logical expressions and banding, or you can use existing filters to build the custom group element. Multiple qualifications are combined with operators such as AND and OR.

By default, only the element names are displayed on a report, but you can change how each element of a custom group is displayed, as described in Specifying how custom group elements are displayed and Enabling hierarchical display of custom groups.

Related Topics

For examples, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help.