MicroStrategy ONE
Access the Advanced Filter Editor and New Qualification Dialogs
Use the Advanced Filter Editor and New Qualification dialogs to set up advanced filtering.
- Open a dashboard. If you want to set up advanced filtering for a visualization, go to step 2. If you want to set up advanced filtering for a metric, go to step 3.
-
Click More in the upper right corner of a visualization and choose Edit Filter.
-
To create a derived metric with advanced filtering, right-click a metric in the Datasets panel and choose Create Metric.
A derived metric with advanced filtering is also know as a conditional metric.
- In Functions pane, select one of the following functions to add it to the derived metric definition in the right pane: Avg, Count, First, GeoMean, Last, Max, Median, Min, Mode, Product, Stdev, StdevP, Sum, Var, VarP, Level.
- Click Add Filter.
- Click Add New Qualification.
Related Topics
Manage Qualifications for an Advanced Filter
Create an Attribute Qualification for an Advanced Filter
Create a Metric Qualification for an Advanced Filter
Create a Metric Set Qualification for an Advanced Filter
Create a Relationship Set Qualification for an Advanced Filter