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
    • Customized Category Color for Dimension
    • Series Properties
    • 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
  • Applying Global Filter
  • Filtering with Not In Option
  • Filter Panel
  1. Applying Filters

Global Filter

The Global filter is meant for the entire Report. It is available on the final page of a Report.

PreviousDate-based View FilterNextExclude from the Global Filter

Check out the given illustration to understand the Global Filter functionality.

Applying Global Filter

  • Click the Global Filter icon provided in the menu panel of a report.

  • A filter panel opens, displaying a list of values that can be used as a filter condition.

  • Click on a Dimension to display a list containing all the sub-dimensions (Clicking a measure or time dimension would display the related fields).

  • Select the In option from the drop-down menu to apply the filtering condition. (E.g., the below-given image displays In as the selected option so that the report gets filtered as per the chosen sub-dimension(s).

  • Select sub-dimension(s) using checkmark(s).

  • Click the Apply icon.

  • The Global Filter icon gets highlighted.

  • The concerned Views of the selected report get customized as per the applied Global Filter condition. E.g., All the displayed Views have been filtered by the selected Global filter value in the below-given image:

Filtering with Not In Option

  • Click the Global Filter icon provided on the final screen of a report.

  • A filter panel opens, displaying a list of values that can be used as a filter condition.

  • Click on a Dimension to display a list containing all the sub-dimensions (Clicking a measure or time dimension would display the related fields).

  • Select the Not In option from the drop-down menu to apply the filtering condition. (E.g., the below-given image displays Not In as the selected option so that the report gets filtered as per the not selected sub-dimension(s).

  • Select sub-dimension(s) using checkmark(s).

  • Click the Apply icon.

  • The Views of a report get filtered by not selected filter conditions. E.g., In this example the Report data gets filtered by the values other than the cities of the Rajasthan.

Filter Panel

The Global Filter provides an option to Attach the selected filter value to the filter panel.

  • Open the Global Filter panel.

  • Click the Attach to filter panel icon.

  • The concerned filter value gets attached to the top filter panel.

  • Choose the sub-value for the attached filter from the top filter panel.

  • Click the Apply option given at the top of the Report.

  • The selected value/sub-value gets applied to the entire Report.

Please Note:

  • A Search bar has been provided for the Global Filter panel to search the available Dimensions, Measures, and Time values.

  • The global filter can be applied only to those Views on the report, where the filter values are used as dimensions.

  • A global filter, when applied to various Views, subdues the View-specific filter values.

  • The user can insert Views created via different data stores in one Report. By default, the Global filter panel displays all the available filter values across the data stores.

Global Filter Functionality
Applying a Global Filter condition
All the saved Views get filtered as per the applied Global Filter
Applying Not In Filtering Condition
Filtered Report Data by not selected Value
Accessing the Attach to filter panel option
Top Filter Panel
Applying Filter Options using the Filter Panel
Filtered Report