Dimension-based View Filter
This page explains steps for View Filter based on data Dimensions.
A Dimension-based View Filter allows users to refine chart data by applying filter conditions to specific dimensions. By selecting sub-dimensions and applying operators such as "In", "Not In", "Like", or "Not Like", users can customize Views to display only the most relevant information.
Steps to Apply a Dimension-based View Filter
Navigate to the Design workspace.
Create a View using a combination of Dimension and Measure.
Click the Filter icon from the Design workspace toolbar.
The Filter panel opens with a list of available filter values.
Select a Dimension → A list of sub-dimensions appears.
Choose a filter condition from the drop-down menu:
In
Not In
Like
Not Like
Select sub-dimensions by checking the box (multiple values supported).
Click the Apply icon.
Filter Conditions
In – Includes only the selected sub-dimension values.
Example: Filter by Region = North, South.
Not In – Excludes the selected sub-dimension values.
Example: Show all regions except North.
Like – Includes sub-dimensions that match a pattern.
Example: Filter by Team Like BU 4 → Shows only BU 4.
Not Like – Excludes sub-dimensions that match a pattern.
Example: Filter by Team Not Like BU 10 → Shows all except BU 10.
Additional Features
Search Bar – Use the search bar in the Filter panel to quickly locate a Dimension, Measure, or Time value.
Apply Filter Button – Ensure you click Apply Filter when enabling or removing filter values to update the displayed chart.
Analyse Mode – The Analyse option enables users to insert, modify, or remove a View-specific filter dynamically.
Last updated