> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Filter

## ${color}[#1a63ba](Filter)

Filters allow you to customize the data exported in your Excel or CSV files. 

Depending on the field type, different filter options are available:

**__Date fields:__**
* after (a date)
* before (a date)
* between (two date values)
* current
* is empty
* last (# of days)
* on (given date)

**__Char fields (e.g. email, name, ...):__**
* equals to any of
* not equal to any of
* is empty
* is not empty
* starts with

**__Special fields:__**
* e.g., Risk Level → choose between High, Low, Medium
* e.g., Status → choose between Open, Closed, Cancelled
* e.g., Product Status → choose between Active, Draft, Archived

**__Quantity fields (e.g., refunded quantity, current quantity)__**
* equals
* less than 
* more than 
* equal or less than
* equal or more than

**Custom Term Filter: **
* The [Custom Term Filter](/en/article/custom-term-filter-1cbi3hk/) allows you to filter any selected text field for custom words or text patterns.


#### ${color}[#1a63ba](Adding and editing filters)

Click on “Add Filter” and select the filter you need for your report.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/filter-button_1qjtst.png)
Take a look at the [Filters FAQ](/en/article/what-are-the-most-commonly-used-filters-and-how-do-they-work-1k6mnjy/) to explore examples of the most commonly used filters.