Condition

Condition is a shortcut function, available for various features in MicroStrategy Web, that allows you to easily define the condition (filtering) of the final metric expression. A conditional metric allows you to apply a filter to only one metric on a report without affecting the other metrics. The metric filter can be either a filter or a prompt that returns a list of filters to choose from. Only one filter or prompt can be associated with each metric, but the metric filter can contain multiple qualifications. For additional information on when to create conditional metrics, see the Advanced Reporting Guide.

Once you select the Condition shortcut function, you can then select the group function for the calculation, such as Sum or Max. Additionally, the options to add or remove a condition are displayed:

• To add a condition to the metric, click the Browse icon () to select a filter or a prompt that returns a list of filters.
• To remove the condition from a metric, click the Delete icon ().

You can also define how the condition is evaluated by clicking Condition advanced options:

• By default, the parts of the report filter that are based on parent or child attributes of the attribute in the metric condition are ignored, and do not affect the calculation of the conditional metric. To apply all criteria in the report filter to the conditional metric, clear the Ignore related report filter elements check box. This option is selected by default.
• By default, the report filter is applied to the metric data and then the metric filter is applied to those results. You can determine the order in which the report filter and metric filter are applied to the metric. From the Interaction between metric filter and report filter drop-down list, select one of the following:
  • To apply the report filter criteria first, then apply the metric filter to the results, select Merge report filter into metric (default). For example, the metric filter is revenue greater than $100 and the report filter is bottom 10 items for sales. In this example, the report filter narrows the result set to only 10 items, and then the metric condition filters out, from those 10 items, any items with a revenue above $100.
  • To evaluate the metric filter first, then apply the report filter to the results, select Merge metric condition into report. Using this option with the example above, the metric condition returns all items with a revenue above $100. The report filter then filters out all but the bottom 10 of those items, based on sales.
  • To combine the metric filter and the report filter, select Merge into new. Only those results that meet both the metric filter and the report filter are included in the metric. Using this option with the example above, the two filters are merged, so that only those items that are in the bottom 10 in terms of sales and that have sales greater than $100 are included.