Dimension-based View Filter

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

Steps to apply Dimension-based View Filter

  • Click the Filter icon from the Design canvas 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.

View with Not In filter condition
  • Then, the View gets filtered by the not selected filter values (In the below-given image, the View gets filtered by not selected value of the dimension).

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 gets filtered by Team BU 4 data.

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 the data other than BU 10.

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 report, and the Global Filter is applied to it.

Last updated