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
-
If the report limit qualification is not already open, double-click the qualification in the Limit definition area of the Report Limit Editor.
-
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.
-
Select the desired attribute(s) from the list of Available objects and click > to add them to the Selected objects list.
-
Click OK. You are returned to the Report Limit Qualification pane.
-
Click OK to close the Report Limit Qualification pane.
-
Click Save and Close. You are returned to the Report Data Options dialog box.
-
Click OK. You are returned to the Report Editor.
-
Save the report. (How?)