Filtering
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.
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.
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. You can use this filter to specify a condition that includes two values connected by a comparison operator.
Click + > Add a Filter.
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.
Hover over a block and click Add a time range filter to this event.
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.
Value counts
Value counts show how often each value occurs in a column. Use them to see what a column holds before you filter on it. A value's percentage is its share of the rows that have a value. Analytics leaves null rows out of that count, so a mostly null column still shows how its values split. The null entry shows its share of every row in the column.
Value counts display in the following places:
- Value list – When you apply a filter, the value list shows each value's percentage. The most frequent values come first.
- Column tooltip – When you hover a column, the tooltip shows its top values and their percentages. It also shows the number of distinct values and the percentage of null values.
If stats for a column have not been collected yet, the tooltip displays a Load stats button. Click it to collect them.
