Does Not Contain (Filter Option)

Does Not Contain (Filter Option)

A couple of users have requested that we add the ability to have 'Does Not Contain' as a filter option. 

This isn't something we currently have in Report Toaster (don't worry - it IS an item on our roadmap, so it's coming soon!) 
In the meantime however, there is a great workaround you can use to replicate this functionality using Saved Filters

For example, suppose I wanted a filter to show an example where the report does NOT contain a certain variable (E.g. Product Title does NOT contain Float). 
This is great to rule out a large chunk of products at once without having to list them all individually. 

To do this, all we need to do is create the filter we want, save the filter, and then use the 'Not in Filter' option to replicate the Does Not Contain functionality. 

Step 1. Create the filter that is the opposite of what I want. In this case, we'll use (Product) Title, contains, Float. 



2.) Save the filter (and give it a name you will remember)



Step 3. Choose the filter from the available options in the dropdown, and then select the option for 'not in filter' 



The end result should look like this. If you're happy with the report, don't forget to save it when you're done. 



And there you have it! 

For a more complete video version of this tutorial guide, check out our video series here. 

    • Related Articles

    • How Do I Use a Filter on a Report?

      Next up in our 'Basics' series, we have how to use a Filter in a Report. This is perfect for when you have the columns you need, and now you want to narrow down, segment, or otherwise filter the data to a specific view. E.g. Show me only Sales to ...
    • How Do I Use Advanced Options?

      Another entry in our 'Basics' series, this article will cover how to used the Advanced Options for Chart reports in Report Toaster.  Note - While included in our Basics series, these Advanced Options are typically intended for more sophisticated ...
    • What's New? - March 2022

      Another month is upon us, and with it comes some exciting new partnerships for Report Toaster.  Let's get started!  Order Tagger  Some of the more keen-eyed among you may have noticed this in the blog when we announced it at the end of February. But ...
    • How to Use Calculated Fields

      In this article, we look at how you can use Calculated Fields to generate better reports for your storefront.  Note: Calculated Fields are created by our Report Toaster staff. Please contact support@cloudlab.com with the details and we will take care ...
    • What's New? - November 2021 (Part 2)

      Well we were going to wait till December to reveal this one, but frankly - we were just too excited!  Device ID (Terminal Number)  So Shopify recently removed both the terminal number and Sales by POS Terminal report in the Shopify admin. For ...

     Suggestion Box

    Didn't find what you were looking for in our knowledge base? Click here to suggest an article, and we'll try to put something together for you.