Filter conditions

In this article, we will see how we can use different filtering conditions for different data types.

There can be 3 basic types of data i.e. numeric, textual or date. We will see one by one the filtering conditions for each of these data types.

  1. Numeric data

    2. Let us consider the ‘sample travel data’ and we have chosen ‘Travel cost’ as a filter. When you edit this filter, you can see the following interface:

    You can see the list of filter conditions that can be used for the numerical data. The significance of each condition is as follows:

    1. Equals: To filter a single value
    2. Not equals: To filter values other than the selected value
    3. Is one of: To filter multiple values
    4. Is not One of: To filter values other than the selected multiple values
    5. Is greater than: To filter values that are greater than the specified value
    6. Is greater than or equal to: Similar to ‘Is greater than’ but also includes the value specified
    7. Is less than: To filter values that are less than the specified value
    8. Is less than or equal to: Similar to ‘Is less than’ but also includes the value specified
    9. In between: To select the range of numerical values
    10. Not in between: Values other than the selected range
    11. In Range: Similar to ‘In between’ but also includes the start and end value.
    12. Not in range: Values other than the selected range(including the start and end value)
    13. Is Null: To filter null values
    14. Is Not Null: To filter all the values other than null values.
    15. Custom: Users can use any one of the mathematical operators manually. From version 4.0 GA onwards, security settings can be enabled for custom filter conditions. For more details, refer to this blog.
  2. Textual data

    3. We consider ‘sample travel data’ and select ‘Employee name’ as a filter. When you edit this filter, the following interface will appear:

    You can see the list of filter conditions that can be used for the Textual data. The significance of each condition is as follows:

    1. Equals: To filter single value
    2. Not Equals: To filter values other than the selected values
    3. Is one of: To filter multiple values
    4. Is not One of: To filter values other than the selected multiple values
    5. Starts with: To filter text by entering few starting alphabets of it
    6. Does not start with: All the text values other than the entered starting alphabets
    7. Ends with: To filter text by entering few ending alphabets of it
    8. Does not end with: All the text values other than the entered ending alphabets
    9. Is Null: To filter null values
    10. Is Not Null: To filter all the values other than null values
    11. Contains: To filter text by entering any sequential alphabets (E.g. “aid” for searching “Haider”)
    12. Does not contains: Inverse of ‘Contains’ filter condition
    13. Custom: Users can use any one of the mathematical operators manually. From version 4.0 GA onwards, security settings can be enabled for filter conditions. For more details refer to this blog.

    Note: All the filter values for Textual data are case sensitive.

  3. Date

    4. We consider ‘sample travel data’ and select ‘Travel date’ as a filter. When you edit this filter, the following interface will appear:

    1. Equals: To filter a single date value
    2. Not equals: To filter values other than the selected date value
    3. Is one of: To filter multiple date values
    4. Is not One of: To filter values other than the selected multiple date values
    5. In between: To select the range of numerical values
    6. Not in between: Values other than the selected range
    7. Is greater than: To filter values that are greater than the specified value
    8. Is greater than or equal to: Similar to ‘Is greater than’ but also includes the value specified
    9. Is less than: To filter values that are less than the specified value
    10. Is less than or equal to: Similar to ‘Is less than’ but also includes the value specified
    11. In Range: Similar to ‘In between’ but also includes the start and end value.
    12. Not in range: Values other than the selected range(including the start and end value)
    13. Is Null: To filter null values
    14. Is Not Null: To filter all the values other than null values.
    15. Custom: Users can use any one of the mathematical operators manually

Note: For all single select values, there is option to pick the dates from the date picker as shown below

To see the overview of how to apply the filters, please refer to the blog filters usage

If you want to hide the filter in report open / dashboard view then select the checkbox against “Hide in report view”. The user will not be able to see the filter in the report open mode. You can change the filter value by appending it in the URL.This feature is used when the filter value is being passed from another application / URL and you do not want the user to change the value of the filter from the frontend.

Hide Filters

You can see mode_of_payment filter but not Booking Platform filter

Filters Hiding

You May Also Like

Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered