Self-Service Visualization
  • What is a Report?
  • Creating a new Report
    • Accessing the Report Module
    • Create New Report
      • Creating a new Report with an Existing Data Store
        • Creating and Updating Instance
      • Creating a new Report by Uploading a File
        • Creating a new Report by Uploading a CSV File
        • Creating a new Report by Uploading an Excel File
      • Creating a new Report with Data Preparation
        • Create a Report with Data Preparation - Inside the Report UI
        • Create a Report with Data Preparation- Partly from Data Center
    • Designing a View
    • Saving Multiple Views
  • Design Canvas
    • Dimension Profiling
    • View Summary
    • Series Properties
      • Customized Category Color for Dimension
      • Series Properties for Measure
    • Create Calculated Field
      • Creating a Formula
        • Record Level Option
        • Summary Level Option
      • Creating Range
    • Order by and Limit
    • Adding a Slicer
  • Chart Gallery
    • Mixed chart
    • Area chart
    • Bar chart
    • Bubble chart
    • Column Stack chart
    • Line chart
    • Pie chart
    • Scattered Plot chart
    • TreeMap chart
    • Circumplex chart
    • Pareto chart
    • Semi Gauge
    • KPI Tile
    • KPI Tile: Comparative Tile
    • KPI Tile: Sparkline
    • Map
    • Data Grid
    • Metric Summary
    • Dissolution/Decomposition chart
    • Spider chart
    • Waterfall chart
    • Funnel chart
    • Inverted Funnel chart
    • Heat Map chart
    • Geo chart
    • Sankey chart
    • Word Cloud
  • Report Final Screen
    • Tab
    • Search
    • Create New ML View
    • Shared Views
    • Live Refresh
    • Export
      • Export Properties
    • Alert Center
    • Change Theme
    • Data Store Information
    • Options Assigned to a View
      • Analyse
        • Timeline Play
        • Data Drills
          • Drill Into
          • Drill Through
      • Edit
      • Duplicate
      • Remove
  • Applying Filters
    • View Specific Filter
      • Dimension-based View Filter
      • Measure-based View Filter
      • Date-based View Filter
    • Global Filter
      • Exclude from the Global Filter
      • Saving a Global Filter
      • Custom View Filter
      • LOV Settings
  • Interactions
Powered by GitBook
On this page
  1. Applying Filters
  2. View Specific Filter

Dimension-based View Filter

PreviousView Specific FilterNextMeasure-based View Filter

Last updated 1 year ago

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.

  • The View Filter icon gets highlighted.

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

  • 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 gets filtered by not selected value of the dimension).

  • 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.

  • 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.

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.​

​

Applying View Filter with In filter condition
The View gets filtered by the selected Filter condition
View with Not In filter condition
Filtered View with Not In filter condition
Filtered View with Like filter condition
Filtered View with Not like filter condition