Top
How can I exclude blank filter values from session analysis?
  • 24 Jul 2025
  • 2 Minutes To Read
  • Dark
    Light
  • PDF

How can I exclude blank filter values from session analysis?

  • Dark
    Light
  • PDF

Article summary

There might be instances when Whatfix is unable to capture the city or country value and it appears as a blank (-) in the Insights data.

Whatfix enables you to exclude such blank values from User filters while analyzing sessions.
trend_insights_data_with_blank_values_session_metrics.png

Note:

  • Blank values might appear in your data due to the following reasons:

    a. Late configuration of filters: User filters, such as User Attributes, might have been configured mid-way and not from the beginning. Hence there might be blank values from the time period when the data is not captured. For example, if Whatfix was deployed on January 1 but the User Attribute is configured only on January 30, data from January 1 to 29 won’t have the attribute value, resulting in blanks.

    b. Configuration issues: If there are issues with the configuration of certain filters, such as User Attributes, blank values might appear in the data.

    c. Unavailable values during data capture: If a filter value is not available in the application when the engagement data is captured, blank values might appear in the data.

  • Currently, Whatfix does not support the exclusion of blank filter values in Event groups, Cohorts, and Dashboards.

Use case

Analyze the number of sessions accessed from any city in the United States without blank values.

Data before excluding blank value:

trend_insights_data_with_blank_values_session_metrics.png

Data setup:

Session metric: Total number of sessions

User filter: City Does not equal to Blank(-) and Country = United States

User breakdown: City

trends_exclude_blank_filters_sessions_example.png

Data after excluding blank value:

trend_insights_data_without_blank_values_session_metrics.png

Use the following steps to exclude blank values from session analysis:

  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.

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

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

    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?

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

  5. Click Choose metric.

  6. Under Session metrics, select the desired session metric.

  7. In the User filter section, click Add user filter and then select the desired filter.

    session_select_user_filter_city.png

    Note:

    The country filter contains blank values. Here’s how the data looks like before blank values are excluded.

    trend_insights_data_with_blank_values_session_metrics.png

  8. Select Does not equal to from the dropdown.

    session_does_not_equal_to.png

  9. Search for blank.

    session_search_blank.png

  10. Select Blank(-), and then click Apply.

    session_select_blank.png

  11. In the User breakdown section, click Add user breakdown, and then select the desired breakdown. In this example, Country is selected.

    session_select_user_breakdown_city.png

  12. Select the Chart type as Table to visualize the data.

    insights_chart_type_table_for_blank_values.png

  13. Scroll down to view the generated data chart. Blank values are excluded from the data.

    trend_insights_data_without_blank_values_session_metrics.png

    Info:

    Filter data based on Daily, Weekly, or Monthly timeframes.

  14. Click Save.


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.