Does Not Contain (Filter Option)

Update 7/27/23 - Since publishing this article, we have added this feature to Report Toaster!



This article has been left published solely for archiving and link purposes :)

-----

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 ...

• Whats New? - August 2023

  It's August, and this month, we're here to talk about some improvements to a few of our reports! Updated Tax Reports We've released a new Tax model that allows us to make some key improvements to our existing suite of tax reports. There are a number ...

• Whats New? - August 2024

  Rounding out the end of the summer, this month we're back to showcase a few quick improvements to Report Toaster :) Let's take a look! Quality of Life Features First, we have a few new quality of life features that we have added to the app to improve ...