Dimension-based View Filter

Check out the given walk-through on how to filter a View based on Dimension value.

• Click the Filter icon from the design mode of a view.

• A filter panel opens with the list of available filter values.

• Select a dimension to display a list containing all the sub-dimensions.

• There are Four(4) types of Filter conditions available on the selected dimension: In, Not in, Like, Not like

• Select the In option as the filter condition from the drop-down menu.

• Select sub-dimension(s) by putting checkmarks in the box (the user can select multiple values).

• Click the Apply icon.

Applying View Filter with In filter condition

• The View Filter icon gets highlighted.

• The concerned view gets filtered as per the applied filter condition(s).

The View gets filtered by the selected Filter condition

• If the selected filter condition is Not In for the View Filter.

• Then, the view gets filtered by the not selected filter values (In the below-given image, the View shows city wise monthly salary data for the middle and old age groups).

Filtered View with Not In filter condition

• If the selected filter condition is Like for the View Filter, the view gets filtered by the given sub-dimension value (In the below-given image, the View shows city-wise total salary data for the males).

Filtered View with Like filter condition

• If the selected filter condition is Not like for the View Filter, the view gets filtered by not selecting the given sub-dimension value. In the below-given image, the view shows city-wise total salary data except for Male, i.e, if there are two sub-dimensions (Male and Female) under the Gender dimension, then the view gets filtered only by the Female's salary value.

Filtered View with Not like filter condition

Please Note:

• A Search bar has been provided in the View Filter panel to search a specific Dimension/ Measure/ Time value from the available list.

​

• The user needs to click the Apply Filter button while enabling or eliminating the View-specific filter values to reflect the same in the displayed chart.

• The user can insert, modify, or remove a view-specific filter via the Analyse option.

• The View Filter becomes ineffective when the selected View is inserted into a story, and the Global Filter is applied to it.​