MicroStrategy ONE
Conditional metrics with multiple qualifications
Only one filter can be associated with a metric, but that one filter can contain as many filter qualifications as needed. For example, you need a report showing a count of customers with the following qualifications:
-
Female
-
Living in the Central region
-
Active customers
Create a filter with those three qualifications, apply the filter to the count metric, and add the metric to the report. The results are displayed below.
The metric definition looks the same as any other conditional metric; the multiple filtering qualifications are contained within the filter placed on the metric. The metric definition is shown below:
[Count of Customers (Customer Lookup)] {~+} <[Active Female Customers in Central Region]>