MicroStrategy ONE
Create Dashboard and Chapter Filters
Create a dashboard or chapter filter by dragging attribute and metrics from the Datasets panel to the Filter panel.
-
Open the dashboard you want to modify.
- Select the chapter to filter.
- Drag the attributes and metrics for filtering from the Datasets panel to Filter panel. Use the Ctrl key to select multiple attributes and metrics.
- Click More
next to the filter and select options for modifying the filter. The available options vary based on the object you select.
- You can apply a filter to a single chapter, multiple chapters, or across your entire dashboard. Click More
next to the filter and choose Apply Selections To and This Chapter Only to use the filter for only the current chapter.
Display Style: Choose the appropriate filter style. See Filter Display Styles for descriptions of each filter style.
Show option for all: Displays an (All) filter option.
Include: Displays data only for the selected values.
Exclude: Displays data for all values, except the selected ones.
Filter by Rank: Ranks the attribute based on the metric you select.
Qualify on Value: Displays data by the selected metric values.
Qualify on Rank: Assigns a numeric rank of Highest, Lowest, Highest %, or Lowest % to the selected metric values.
Choose All Chapters Containing This Filter to use the filter across all chapters it is added to. If you want to apply the filter across your entire dashboard, add it to the remaining chapters. Any changes you make to the filter are then reflected across your entire dashboard.