Source: https://nishanth-fern-test.docs-staging.pageloop.ai/analytics/how-can-i-exclude-blank-filter-values-from-session-analysis

# How can I exclude blank filter values from session analysis?

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](https://support.whatfix.com/product-analytics/docs/analyze-sessions-using-trend-insights). ![trends\_session\_data\_with\_blanks.png](/images/f9/trends_session_data_with_blanks-f9a33a21.png)

> [!WARNING]
>
> - 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 India without blank values.

**Data before excluding blank value**:

![trends\_session\_data\_with\_blanks.png](/images/f9/trends_session_data_with_blanks-f9a33a21.png)

**Data setup**:

**Session metric:** Total number of sessions

**User filter**: City Does not equal to Blank(-) and Country = India

**User breakdown**: City

![trends\_session\_data\_blank\_value\_removal\_data\_setup.png](/images/1e/trends_session_data_blank_value_removal_data_setup-1ee42737.png)

**Data after excluding blank value**:

![trends\_session\_data\_without\_blanks.png](/images/55/trends_session_data_without_blanks-5539a03d.png)

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

1. On the [Whatfix Analytics dashboard](/analytics/how-can-i-access-the-product-analytics-dashboard), click **Insights**. ![pa\_click\_insights\_left\_pane.png](/images/8a/pa_click_insights_left_pane-8a8a32a5.png)

2. Click **Create Insight**. ![pa\_click\_create\_insight.png](/images/d7/pa_click_create_insight-d7964b8a.png)

3. Click **Trend Insights**. ![pa\_click\_trend\_insights.png](/images/a5/pa_click_trend_insights-a58dbddc.png)

4. Click the **Give your insight a name** textbox and enter a name for your Insight.

![](/images/66/trend_give_your_insight_a_name-66798cfc.png)
2\. Click the **Description** text box and enter a description that explains what the Trend Insight is about.

![](/images/bd/trend_enter_a_description-bdbf8596.png)
3\. From the **Select user type** dropdown, choose whether to analyze data for **All users**, **Identified users**, or **Anonymous users**.

![](/images/56/trend_insight_select_anonymous_users-5664e5a8.png)

Note:

- By default, Insights data might 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](/images/2b/insights_event_identification_rate-2bffbd53.png)

- For more information on filtering users and understanding the Event identification rate, see [How can I filter unidentified users in Insights?](/analytics/how-can-i-filter-unidentified-users-in-product-analytics)

4. Click the **Data source** icon and [select the stage](/analytics/get-analytics-data-across-clm-stages) from which you want to get the data.

![](/images/fd/trend_insight_data_source_option-fd526db8.png)
5\. Click **Choose metric**.

![](/images/5a/trends_choose_metric-5a17ef59.png)
6\. Under **Session metrics**, select the desired session metric.

![](/images/6b/session_analytics_session_metrics_choose_session_metric-6b85b310.png)
7\. In the **User filter** section, click **Add user filter** and then select the desired [filter](/analytics/user-filters-in-insights).

![session\_select\_user\_filter\_city.png](/images/fb/session_select_user_filter_city-fba66269.png)

> [!WARNING]
>
> The country filter contains blank values. Here’s how the data looks like before blank values are excluded.
>
> ![trends\_session\_data\_with\_blanks.png](/images/f9/trends_session_data_with_blanks-f9a33a21.png)

8. Select **Does not equal to** from the dropdown.

![session\_does\_not\_equal\_to.png](/images/ab/session_does_not_equal_to-abff330e.png)
9\. Search for blank.

![session\_search\_blank.png](/images/b3/session_search_blank-b338bc30.png)
10\. Select **Blank(-)**, and then click **Apply**.

![session\_select\_blank.png](/images/25/session_select_blank-25a2f4ee.png)
11\. In the **User breakdown** section, click **Add user breakdown**, and then select the desired [breakdown](/analytics/user-filters-in-insights). In this example, **Country** is selected.

![session\_select\_user\_breakdown\_city.png](/images/fc/session_select_user_breakdown_city-fc0544a5.png)
12\. Select the **Chart type** as **Table** to visualize the data.

![trends\_chart\_type\_table.png](/images/4e/trends_chart_type_table-4ee2a645.png)
13\. Scroll down to view the generated data chart. Blank values are excluded from the data.

![trends\_session\_data\_without\_blanks.png](/images/55/trends_session_data_without_blanks-5539a03d.png)

> [!INFO]
>
> Filter data based on **Daily**, **Weekly**, or **Monthly** timeframes.
>
> ![](/images/d5/date_week_month-d554a7a1.png)

14. Click **Save.**

![](/images/22/trends_click_save_option-22d8e5de.png)

Shows overall behavior and engagement for both identified and anonymous (unidentified) users.

Users that Whatfix can detect and identify using a unique User ID.

Users that Whatfix cannot identify. These users are denoted by the Anonymized Whatfix IDs rather than an actual User ID.
