Insert Function Wizard: Parameters

The Parameters page is displayed if the selected function requires parameters, which allow you to determine the behavior of the function. For example, the NTile function has two parameters, Ascending and Tiles. Ascending controls whether the NTiles are ordered in ascending or descending order, while Tiles sets the number of splits.

Example syntax and a description of the selected function are displayed at the top of the page, followed by a list of all required parameters.

You have the following options:

• Select a parameter to modify: If a parameter has options, a drop-down list is available from which to choose. Otherwise, enter the value for the parameter.

  : For more information on the parameters for specific functions, see Using functions in MicroStrategy and the Functions Reference.

• Toggle the display of function parameters: The Show function parameters in the formula when viewed in the expression box check box toggles the display of parameters in the expression, once you return to the Metric Editor. It is available only when the wizard is accessed from the Metric Editor.

To continue the wizard, click Next. Depending on whether the selected function requires additional parameters, the next page can be any of the following:

• Break-By

• Sort-By

• HasResidue: This parameter is available only for the functions Banding, BandingP, and BandingC.

  HasResidue is a TRUE/FALSE parameter that defines whether an extra band is created for all values that do not fall within the range of values defined by the banding function. 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.

If Next is disabled, the function does not require any further input. Click Finish to enter the function into the expression.