MicroStrategy ONE

Steps to set break by values in a metric limit

The break by functionality allows you to choose the attribute level at which to restart counting rank or percent values for the metric in a metric limit.

Prerequisite

This procedure assumes you have already created a metric limit and set the Function to Rank or Percent. For more information, see Steps to create a report limit.

To set break by values in a metric limit

  1. If the report limit qualification is not already open, double-click the qualification in the Limit definition area of the Report Limit Editor.

    Open the Report Limit Editor

  2. Click Break By. The Breakby tab of the Level dialog box opens.

    The Break By button is enabled only if you set the Function to Rank or Percent.

  3. Select the desired attribute(s) from the list of Available objects and click > to add them to the Selected objects list.

  4. Click OK. You are returned to the Report Limit Qualification pane.

  5. Click OK to close the Report Limit Qualification pane.

  6. Click Save and Close. You are returned to the Report Data Options dialog box.

  7. Click OK. You are returned to the Report Editor.

  8. Save the report. (How?)