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

• Why Do I Have No Data In a Report?

  This guide is intended to help users troubleshoot common causes for having no data in a report. 1.) Account is still syncing your store data This is by far the most common cause of having no data in a report. Usually this is the case when you have ...