---
title: Filtering
slug: analytics/docs/filtering
docTags: 
createdAt: 2026-07-20T15:45:13.573Z
---

Analytics maintains consistent data filtering across explorations and model behavioral semantics. The filtering layer comprises various options to facilitate conditional data, group, aggregate, block, property, value, and time-based filtering.

## Filtering options

Based on your analytics and data processing needs, you have the following filtering options distributed across functions.

### Entity filter

Entity filters help you perform conditional filtering in data definition and analysis. Click the filter icon to access and enable the filtering options in [exploration templates](docId\:u2tlXpjocdzP6-_-Odi10).

![Analytics\_Filtering\_1.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/0nCzd-9ezuZP1w1Yt9BPy-20260720-144935.png)

Click **+ > Add a Condition** or **+ > Add a Group** to establish one or more conditions. Structure these conditions hierarchically, with nested "and" or "or" conditions forming groups that can expand to unlimited levels.

:::hint{type="info"}
**Note**

Choose filtering conditions and their values from four tabs in the drop-down lists: catalog, blocks, values, and parameters. For string data, the comparison is case-insensitive.
:::

The comparison operators used in each condition are as follows:

- **is** – Checks if the left side equals the right.
- **is not** – Checks if the left side does not equal the right.
- **contains** – Determines if the left side string contains the right side as a substring.
- **in** – Checks if the left side is present within the set of values on the right side.
- **\<, >, >=, \<=** – Applies mathematical operators.
- **not contains** – Checks if the left side is a string that does not contain the right side as a substring.
- **not in** – Checks if the left side is not present within the set of values on the right side.

Properties used for comparison may include catalog properties such as columns, derived columns, blocks, values, or parameters.

### Property filter

Property filters let you specify conditions inside blocks within [cohorts](docId\:qqERbaNW3LL9kPlSp27Lr). You can use this filter to specify a condition that includes two values connected by a comparison operator.

Click **+ > Add a Filter**.

![Analytics\_Filtering\_2.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/veOX0K_IpwIeZAwJyIrKi-20260720-144935.png)

The comparison operators used in each condition are as follows:

- **is** – Checks if the left side equals the right.
- **is not** – Checks if the left side does not equal the right.
- **contains** – Determines if the left side string contains the right side as a substring.
- **in** – Checks if the left side is present within the set of values on the right side.
- **\<, >, >=, \<=** – Applies mathematical operators.
- **not contains** – Checks if the left side is a string that does not contain the right side as a substring.
- **not in** – Checks if the left side is not present within the set of values on the right side.

Properties used for comparison may include catalog properties such as columns, derived columns, blocks, values, or parameters.

### Time filter

Time filters let you filter events based on their time of occurrence.

![Analytics\_Filtering\_3.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/-RV8llG13aajy5LGYwYx7-20260720-144935.png)

You can use this filter in the following modes:

- **Relative** – Filter events relative to the current time, such as *last 3 months* or *all time*.
- **Absolute** – Filter events using a time window based on absolute dates, optionally including the time of day.
- **Relative to Event** – Filter events based on the relative duration between an event and a specified baseline event or timestamp, such as within 2 weeks after the event's onboarding first occurrence.

### NetScript filter

Use the NetScript filter as an alternative for defining filtering conditions with NetScript instead of a regular expression tree-based interface.

For detailed documentation on syntax and functions, refer to the [NetScript language reference](docId:8NvhL6PRcYM9S-k6jD1N1).

## Value counts

Value counts show how often each value occurs in a column. They display in the following places:

- **Value list** – When you apply a filter, the list of values shows each value's percentage of the column's rows, with the most frequent values first.

![screenshot of the platform value drop-down list where each value shows its percentage of the column and the header shows three distinct values](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/JVXu6i01hzkj38G9B67w6_select-condition-value-based-on-percentage.png)

- **Column tooltip** – When you hover a column, the tooltip shows its top values, number of distinct values, and percentage of null values.

  ::Image[]{src="https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/YWg7_Hgk9k4Hd4CJ-UWcF_top-values-details.png" size="50" alt="screenshot of the genre column tooltip where TOP VALUES lists Drama at 18%, Comedy at 15%, Action at 15%, and Horror at 9.3%, with 20 distinct values and 0% null" isUploading="false" showCaption="false"}

If stats for a column have not been collected yet, the tooltip displays a **Load stats** button. Click it to collect them.

![screenshot of a column tooltip with the Load stats button](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/55nXm7a2bWomy0OisH0fK_click-load-stats-to-collect-stats-if-uncollected.png)