Skip to content

Insights

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. trends_session_data_with_blanks.png

  • 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

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

Data after excluding blank value:

trends_session_data_without_blanks.png

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

  1. On the Whatfix Analytics dashboard, click Insights. pa_click_insights_left_pane.png

  2. Click Create Insight. pa_click_create_insight.png

  3. Click Trend Insights. pa_click_trend_insights.png

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

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

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

trends_session_data_with_blanks.png

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

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

trends_session_data_without_blanks.png

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

  1. Click Save.

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.