Customize Fields

Filter

Filtering a Dataset Using the UI

  1. Start by navigating to the dataset you want to filter.
  2. Click on the top right button with the filter icon.
  3. A menu will appear where you can add a name for the view to help you identify the query.
  4. Choose the appropriate filters under the “Include filters” section, such as country, job title, or date.
  5. Click the “create subset” button to create the filtered view.

Filter Functions

Select

  • Use this function to select one or more exact matches from a predefined list, such as countries or regions. This is useful when dealing with a known set of values.

Boolean

  • Filter by boolean values (true or false) to find specific records meeting criteria, such as verified or unverified social media profiles.

Date

  • Use this filter to specify a date range, with start and end dates, useful for trend analysis or filtering events by date.

Number

  • Options include:
    • Is: Matches exact numerical values.
    • Not: Excludes specified values.
    • Exist: Filters non-empty numerical fields.
    • List (exact match): Matches exact values from a list.
    • Lower than / Lower or equal to: Filters values below or up to a specific number.
    • Greater than / Greater or equal to: Filters values above or up to a specific number.

String

  • Filter by string values using options like exact match, exclusion, list matching, or pattern inclusion to refine searches.

Array

  • Use the “Array includes” filter to check if a value exists within an array field, such as specific tags.

Creating Rule-Based Group Filters

  • Create group filters by clicking on the “+Add filter” dropdown and selecting “Add group.”
  • Group filters allow you to set rules, such as filtering a dataset where the category is “Electronics” and the brand is “Dell” or “Apple.”

Limitations

  • Groups cannot be nested, and a maximum of two groups per filter is allowed.

If you require more complex queries, contact your account manager for assistance with custom queries and filters.