How can I exclude filter values while analyzing events?

  • Updated On Jul 24, 2025
  • Published on Oct 10, 2023
  • 2 minute(s) read
Prev Next

Sometimes, you might want to eliminate specific filter values and visualize data with all other filter values. Excluding a filter helps you focus only on the data required for analysis.

Use case

Consider that you've rolled out a Pop-up for your customers. You want to use Trend Insights to analyze the number of people who triggered the URL in the Pop-up from all countries, except India.
Whatfix enables you to exclude India from the User filter and provides analytics data from all other countries.

Data without the filter value excluded:
trend_insights_filter_value_not_excluded.png

Data setup:
trend_insights_filter_value_excluded_data_setup.png

Event metric: Total events
Guidance event: URL Triggered via Pop-up
User filter: Country Does not equal to India
User breakdown: Country

Data after the filter value is excluded:
trend_insights_filter_value_excluded_country.png

Info:

Use the following steps to exclude filter values during event analysis:

Note:

The following steps show how to exclude filter values in Trend Insights. The process is similar for Funnel Insights, Event groups, and Dashboards.

  1. On the Whatfix Analytics dashboard, click Insights.
    ia_left%20nav_insights

  2. Click Create insights.
    create_insights

  3. Click Trend Insights.
    trend_insights

  1. Click the Give your insight a name textbox and enter a name for your Insight.
    trend_give_your_insight_a_name.png

  2. Click the Description text box and enter a description that explains what the Trend Insight is about.
    trend_enter_a_description.png

  3. From the Select user type dropdown, choose whether to analyze data for All users, Identified users, or Anonymous users.
    trend_insight_select_anonymous_users.png

Note:
  • By default, Insights data may contain identified (users identified by User ID) and unidentified (users not identified but denoted by Anonymized Whatfix IDs) users.
  • The Event identification rate indicates the percentage of events Whatfix is able to attribute to uniquely identified users.
    insights_event_identification_rate.png
  • For more information on filtering users and understanding the Event identification rate, see How can I filter unidentified users in Insights?

  1. Click the Data source icon and select the stage from which you want to get the data.
    trend_insight_data_source_option.png

  2. Click Choose metric.
    trends_choose_metric.png

  3. Under Event metrics, select Total events or Unique users as required.
    trends_select_event_metrics.png

  4. Click Add event and then add the required Guidance events, App events, or Event groups.
    trends_insights_click_add_event.png

  5. Click Add user filter and select the required User filter.
    insights_select_user_filter_for_blank_values.png

  6. Select the condition as Does not equal to from the dropdown.
    equal_condition

Info:

In this example, we want to filter the number of users who've seen a Pop-up from all countries except India.

  1. Select the filter value that you want to exclude, and then click Apply.
    select_user_filter

  2. Click Add user breakdown and select the criteria to breakdown the data.
    trend_insights_click_add_user_breakdown.png

  3. Scroll down to view the generated data chart.
    trend_insights_filter_value_excluded_country.png

Note:

The data chart is generated without the data for the excluded filter. It is excluded from the User breakdown as well.

  1. Click Save.
    trends_click_save_option.png