Filtering

  • Updated

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.

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

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.

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

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.