Index Pages
Introduction
Dimension Vs Measure
Data Formatting
Bins
Filters
Sets
Data Blending
Group
Hierarchies
Parameters
Calculated Field
Saving and Exporting
Sorting
Functions
Functions Classifications
Aggregate Functions
IF Function
Case Function
Date Functions
Date Format
Actions
Filter Actions
Highlight Actions
URL Actions
Annotations
Mark
Point
Area
Classification of Charts
Classification of Charts
DashBoards
Story Line
Table Calculations
Custom SQL
Analytics
Faqs

 

    Filters

  • It hides unwanted records (or) retrives wanted records by hiding unwanted recors

    •  

    Worksheet level: filter applicable to that particular sheet only.
    Data Source level: Filter applies to all the sheets using that data source.

     

    Worksheet level:
     Header level
     Data view level
     Using marks card
     Quick filter
     Context filters
     Cascading filter.

    CONTEXT FILTER: If we want to make one filter output depending on other filter we have to use context filter.

     

    Filters - Data source level

     

     

     

    Filters - Condition

     

  • AND Operator

    •  

     

    Filter on DIMENSIONS:

     

    Filter on MEASURES:

     

     

    Date Filters:

  • Relative Dates denotes specific Time

    •  

     

     

    Create TOPN Customers

     

     

    Result

     

     

    Data source level Filter

     

     

     

     

     

     

    Filtering Manual selection

     

     

     

     

     

     

    Filtering with WILDCARD CHARACTERS

     

    hi