Advanced Filters for Precise Reporting

Whatsdash™ offers powerful filters that allow you to narrow down your reports based on various criteria, such as size, color, payment status (paid, cancelled, pending), created date, total spent, order count, and more.

Where to Find These Filters?

Table of Contents :

1. How does the 'Contains' & 'Not Contains' Filter Work?

• Contains -
  The 'Contains' filter is used when you want to view specific fields that contain certain words. For example, imagine a store that sells a variety of clothing items, such as T-shirts, Jeans, Jackets, Hats, and Sweatshirts. If you want to filter products that contain the word "Jeans", you can use the 'Contains' filter.

When you apply the 'Contains' filter for the word "Jeans", the report will show only the items with "Jeans" in their name, such as Blue Jeans and Black Jeans, and exclude all other products.





• Not Contains -
  The 'Not contains' filter is used when you want to exclude specific fields that contain certain words. For example, imagine a store that sells a variety of clothing items, such as T-shirts, Jeans, Jackets, Hats, and Sweatshirts. If you want to exclude products that contain the word "T-shirts", you can use the 'Not contains' filter.

When you apply the 'Not contains' filter for the word "T-shirts", the report will show only the items that do not have "T-shirts" in their name, such as Jeans, Jackets, Hats, and Sweatshirts, and exclude all products with "Jeans" in their name.

Note: You can add multiple filter values using the 'Contains' and 'Not Contains' filter conditions to refine your results further.

2. How does the 'Is' and 'Is Not' filter work?

• Is -
  The 'Is' filter retrieves results that exactly match the specified parameter.

For example, if you apply the 'Is' filter to an Order Status with the parameter "Shipped", the report will display only orders that have a status of "Shipped".





• Is Not -
  The 'Is Not' filter excludes results that match the specified parameter.

For example, if you apply the 'Is Not' filter to an Order Status with the parameter "Pending", the report will exclude all orders marked as "Pending" and show only orders with other statuses, such as "Shipped", "Delivered", or "Cancelled".

3. How Do 'Include' and 'Exclude' Filters Work?

• Include -
  The Include filter allows you to add multiple filter conditions to narrow down results.

For example, imagine you want to focus on two product titles: "Wireless Keyboard" and "Gaming Mouse", among a list of other product titles.
When you apply the Include filter with these conditions, the report will show only the products titled "Wireless Keyboard" and "Gaming Mouse", excluding all other products.





• Exclude - The Exclude filter is used to remove multiple filter conditions from the results.

For example, if you want to exclude the product titles "Wireless Keyboard" and "Gaming Mouse" from your report, you can apply the Exclude filter with these conditions.
When this filter is applied, the report will remove "Wireless Keyboard" and "Gaming Mouse" from the results and display all the remaining product titles.

4. How does the 'Is Blank' & 'Is Not Blank' filters work?

• Is Blank -
  The 'Is Blank' filter condition is used to find records where a specific field is empty or has NULL values.

For example, if you want to filter all customer profiles without a phone number, applying the 'Is Blank' filter on the phone number field will show only the records where the phone number is missing in the system.





• Is Not Blank -
  The 'Is Not Blank' filter condition is used to find records where a specific field has a value.

For example, if you want to filter all customer profiles that have a phone number, applying the 'Is Not Blank' filter on the phone number field will show only the records where a phone number is recorded in the system.

5. How do 'Begins With' & 'Ends With' work?

• Begins With -
  The 'Begins With' filter helps find records that start with a specific prefix.
  
  For example, if you want to filter all product codes that begin with "PRO", applying the 'Begins With' condition will retrieve all records with product codes like "PRO123", "PRO456", and "PRO789".

  



• Ends With -
  The 'Ends With' filter helps find records that end with a specific suffix.
  
  For example, if you want to filter all product codes that end with "99", applying the 'Ends With' condition will retrieve all records with product codes like "A199", "B299", and "C399".