Filter Conditions

Based on the kind of data that has been used as a filter, we get various kind of filtering condition. In this blog we will cover the same.

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:

We have selected the Numeric column as a filter. When you select this on the filter, you can see the list of datatypes here:


You can see the list of filter conditions that can be used for the numerical data:

  1. Equals: This is single select. It can be used to filter a single value
  2. Not equals: This is also single select, it will filter values other than the selected value
  3. Is one of: Multiselect, to filter multiple values
  4. Is not One of: Multiselect, 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. When this is selected there is no option to select any value.
  14. Is Not Null: To filter all the values other than null values. When this is selected there is no option to select any value.
  15. Custom: Users can use any one of the mathematical operators manually.

2. Textual data:

We have selected the Textual column as a filter. When you select this on the filter, you can see the list of datatypes here:


You can see the list of filter conditions that can be used for the Textual data:

  1. Contains: To filter text by entering any sequential alphabets (E.g., aid for searching “Haider”)

    2. Filter Conditions
    Filter Conditions

  2. Custom: Users can use any one of the mathematical operators manually.
  3. Does not contain: Inverse of ‘Contains’ filter condition
  4. Does not end with: All the text values other than the entered ending alphabets
    Filter Conditions

    Simply we use here Does not end with “r”

    5. Filter Conditions

  5. Does not start: with All the text values other than the entered starting alphabet
    Filter Conditions

    Simply we use here Does not start with “B”

    6. Filter Conditions

  6. Ends with: To filter text by entering a few ending alphabets of it
    Filter Conditions

    Simply we can use here End with “er”.

    7. Filter Conditions

  7. Equals: To filter single value
  8. Is Not Null: To filter all the values other than null values. We can not select any value here from the frontend.
  9. Is Null: To filter null values. We can not select any value here from the frontend.
  10. Is one of: To filter multiple values
  11. Is not One of: To filter values other than the selected multiple values
  12. Not Equals: To filter values other than the selected values
  13. Starts with: To filter text by entering few starting alphabets of it

3. Date:

We have selected the Date column as a filter. When you select this on the filter, you can see the list of datatypes here:

Filter Conditions

You can see the list of filter conditions that can be used for the Date.

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

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

Filter Conditions

NOTE: In case of “Is Null”, “Is not null” when at the frontend nothing is selected, then you might not want to show this filter at all while viewing the report. In that case the “Hide in View” option can be used using which the filter will not be visible at the report viewing level.

Filter Conditions

Thank You,
Helical Insight

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