Skip to main content
Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

Filtering Dashboards (EX)

What's on This Page:


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


Qtip: This page describes functionality available to Engagement, Lifecycle, Ad Hoc Employee Research, and 360 projects, although Lifecycle, Ad Hoc Employee Research, and 360 do not have hierarchies. For more details on each, see Types of Employee Experience Projects.

About Filtering Dashboards

You can filter your dashboards by applying a filter to every widget on a page or by applying filters to individual widgets. This allows you to dive into the data and find trends that you would not be able to see with the data in aggregate alone.

Detailed below is how to add and use dashboard page filters; if you would like more information about widget-level filters, visit the Widget-Level Filters section of the Widget Overview support page.

Note that adding filters in this manner only makes the filter available for dashboard viewers to use. When viewing a dashboard, you will still have to click your filter and define its conditions in order to have it apply to your results.

Qtip: By default, dashboard page filters aggregate data across all mapped data sources. To limit what data sources are included in your filters, enable the Limit page filters to specific data sources setting in your Dashboard Settings.

 

Filtering Dashboards by a Hierarchy

Some widgets require a hierarchy in order to function properly. Therefore, it is important to add a hierarchy filter to your dashboard first.

  1. Select Edit Page to enable editing on your dashboard.
    Edit Page button on the upper-right of the dashboard
  2. Click Add a Filter and choose your hierarchy.
    Add Filter dropdown along the upper-left asks for a hierarchy to be selected
  3. Click the dropdown menu. Change your Filter Title, if desired, and choose the default hierarchy for the dashboard under Field.
    Filter dropped down to reveal a menu where the title of the filter and the item filtering the dashboard can be changed

    Qtip: The hierarchy selected under Field will be automatically applied for any dashboard viewer. It is the default hierarchy that the dashboard can be filtered by.
  4. Select Done Editing when finished.
    Done Editing button in upper-right of the dashboard

Adding Filters to Dashboard Pages

You can also filter your dashboard pages based on questions, Embedded Data, and metadata.

  1. Select Edit Page to enable editing on your dashboard.
    Edit Page button on the upper-right of the dashboard
  2. Click the plus sign ( + ).
    Plus sign expands huge filter list
  3. Choose the field you want to filter by.
    Qtip: Different data types will result in different kinds of filter options. For example, Text Sets will give you a dropdown list of options, while Numbers will give you a slider scale from which to select a number range (the number range corresponds to the answer choices’ recode values). You can change the data types of your questions and metadata inside the Dashboard Data.
  4. Next, decide the values you want dashboard users to be able to filter by.
    Choosing fields people can filter by

    Example: Using this screenshot as an example, if you select “All,” users can switch between filters for high and low attrition risk, or combine the two. If you select only “High Risk,” users will not be able to select the “Low Risk” option.
  5. Decide whether you want to lock the filter. This prevents users from changing it.
    Lock filter is towards the bottom of a filter. Not selected here

    Warning: Locked filters are not a replacement for applying data restrictions to dashboard viewers. If you need to limit what data your dashboard viewers have access to, we highly advise you set up data restrictions using roles.

Applying Filters

Qtip: If you have enabled editing on your dashboard, the filters you select will not just filter the dashboard for you, but change the filter settings available to dashboard users. Click Done Editing to disable editing and then apply filters.

Filter opened on a dashboard not in editing mode

  1. Click on the filter you want to use.
  2. Use the dropdown to select the data criteria that you want to view.

Using an Org Hierarchy Filter

To use an org hierarchy filter, click on the filter and choose the unit you want to view.
clicking the hierarchy filter and choosing a unit

Qtip: If a unit is grayed-out, that means you do not have permission to view data in that unit.

The main parts of an org hierarchy filter are:
a hierarchy filter expanded to show all parts

  1. The org hierarchy filter appears at the top of the dashboard.
  2. Use the search bar to search for a specific hierarchy unit.
  3. If your dashboard has multiple hierarchies, you can use the dropdown menu to switch between hierarchies.
  4. The currently selected unit will be highlighted in blue. You can select a new unit by clicking a unit from the list.
  5. If desired, enable the Direct Reports Only checkbox. When this box is checked, the dashboard will only show data for participants marked as a direct report in the selected hierarchy unit. In other words, this option excludes manager response data.

When using the filter, it is important to pay attention to what data is included in your selected unit. If you select a unit that has sub-units, the sub-unit data will also be included.

Example: In this example, the Division E unit is selected. This unit has two sub-units: BU 1 and BU 2. When Division E is selected, you will see the data for participants in Division E, BU 1, and BU 2.
an org hierarchy filter. the division e unit is selected and contains two sub units

Selecting Multiple Units with an Org Hierarchy Filter

Qtip: You are reading about functionality is currently rolling out. Customers enrolled in the Enhanced Anonymity for Org Hierarchy preview will not get access to this feature until Enhanced Anonymity for Org Hierarchy becomes generally available.

When filtering your dashboard by an org hierarchy, you can select multiple units to include in the filter. Results are aggregated across all selected units when multiple units are selected.

Example: In this example, we’ve selected three units in our org hierarchy filter, as indicated by the units being highlighted in blue.
selecting multiple units in an org hierarchy filter

Please be aware of the following limitations and interactions when filtering for multiple org hierarchy units:

  • You may select up to 10 units with your org hierarchy filter.
  • The Direct Reports Only filter option changes the behavior of selecting multiple units. Note that this option is disabled by default:
    • Disabled: When disabled, you cannot select units that are direct ancestors or descendants of other units. This is to prevent the double counting of responses.
      Example: In this example, Judy Houchins and Sylvia Twitty are child units of Diane Hall and they are initially selected in the hierarchy filter. Since direct reports only is disabled, when Diane is selected, the other two units are deselected. Similarly, if Judy or Sylvia are reselected, then Diane will be deselected.
      the direct reports only option disabled causing ancestor units to deselect
    • Enabled: When enabled, you can select units that are direct ancestors or descendants of other units. This is because you are only displaying direct reports, meaning responses will not be double counted when units with the same ancestry are selected.
      Example: In this example, Glen Noel, Gwendolyn Sims, and Kathleen Alvarez are child units of Jack Morin. Since direct reports only is enabled, when Jack is selected, all units remain selected.
      the direct reports only option enabled allowing units with the same ancestry to be selected
  • If the number of responses for a unit is below your anonymity threshold, then you cannot select that unit for filtering. This is to protect the anonymity of respondents; even if the total aggregate number of responses is over the threshold, you cannot select an individual unit if the number of responses in that unit is below the anonymity threshold.
  • Enhanced anonymity is supported for multi-select org hierarchy filters.
  • Action planning does not support multi-select org hierarchy filters. You must filter for one unit with action plans.
  • If a dashboard uses multiple data sources with a hierarchy filter and hierarchy mapping, then historical comparisons will show aggregated data for only the available mapped units when multiple hierarchy units are selected.
  • If you have a dashboard comparison set up for parent unit, and you select multiple units in your org hierarchy filter, then the comparison will behave as follows:
    • The comparison will populate with data if the parent unit of the selected units are the same.
      selecting multiple units with the same parent unit and comparisons populate
    • The comparison will populate with a dash if the parent unit of the selected units is not the same.
      choosing multiple units with different parent units and comparisons do not populate

Removing Filters

  1. Select Edit Page to enable editing on your dashboard.
    Edit Page button on the upper-right of the dashboard
  2. Click on the filter you want to remove.
    Filter want to remove opened, remove filter option at very bottom with a big X next to it
  3. Select Remove Filter.

Filter Interactions

Filters & Response Rates/Participation Summary Widgets

Response Rates and Participation Summary widgets can only be filtered by Org Hierarchies and participant metadata. The widgets will instead display an error message if they are filtered by a different field type. Simply remove the filter to avoid this error message.

Qtip: Interested in seeing response rates based on demographic information? Check out the Response Rates widget page for information on applying a break-out instead.

Filters & Sensitive Fields

If a field is marked as sensitive in your Dashboard Data and the dashboard user has the permission to View Sensitive Fields disabled, they will not be able to view or interact with that filter until the field is no longer marked as sensitive or the user’s permissions are changed. If you set your default filter value for a sensitive field to something other than All, it is possible that the dashboard user will not be able to see any data if they do not have the ability to View Sensitive Fields.

Dashboard Page & Widget-Level Filter Interactions

Generally speaking, page filters will apply to widgets that also have a widget-level filter applied. However, in circumstances where the widget-level filter and page filter conflict, the widget-level filter will override the page filter.

For example, if a page filter is set to show only responses from male respondents and a specific widget has a filter to show only responses from female respondents, the page filter will be ignored and the widget will only show female responses.

However, in a situation where a page filter does not completely contradict a widget-level filter, both filters will be applied. For example, if a filter is set to only show responses from male respondents and the widget-level filter is set to show only responses from participants ages 18-24, then the widget will show responses for males who are 18-24 years of age.

Filter Pages Independently

You can choose whether you want your dashboard’s users to be able to filter pages independently. For example, let’s say you add a date filter to the Overview page. You may not want this to carry over as you visit other dashboard pages.

To keep page filters separate from one another, go to your dashboard Settings and enable Filter pages independently.

Last option on the dashboard settings page

When enabled, filter selections will only apply to the selected page. When disabled, applied filter selections will persist when navigating to other pages.

Qtip: Org Hierarchy page filters do not follow this setting. Org Hierarchy filters will always apply to every page in your dashboard if you use them.
Qtip: Filter pages independently will be disabled by default. You need to manually turn it on in dashboards where you wish to use it.

Exclusively is “X”

For fields that have been mapped as Multi-Answer Text Sets, you will have an option called Exclusively is ‘X’ when adding the field as a filter. When selecting this option, the filter will only return data if the user responded with exactly your selection.

Exclusively is "X" checkbox

For example, if the question was, “What modes of transportation do you use: Train, Car, Bus” and you specified “Exclusively is: Train, Car,” you would only get responses where the user selected both Train and Car, nothing else.

Date Filters

Filters made for fields of the Date field type are unique in a couple of ways. For one, when specifying the date range, you have a lot of unique options. In addition, these filters themselves have ways of offsetting the data you pull in.

Specifying the Date Range

  • Today/This Week/Last  Days/Last 180 Days/etc.: This date range is dynamic. If you have “This Week” selected, the data that appears will literally be from the past week, changing as you progress through weeks.
  • Custom Date Range: Using the calendars, specify the dates over which you want data included.
    Custom Range filter
  • Custom Time Frame: Custom Time Frame allows you to filter for data collected within the last number of days, weeks, months, quarters, or years. You then have the option to “Shift back” the data by a given period of time. This “Shift back” is described below. For example, in looking at data from the last two quarters, you can “Shift back” by one year to see what the data looked like in the same two quarters one year ago. The filter will describe the exact dates it is covering.
    Custom Time Frame filter

Shift back by Quarter or Year

When you select a preset timeframe like Last 180 Days, or choose Custom Timeframe, you can select Shift back by to adjust the data being displayed in the dashboard to the same period in the amount of time specified. For example, let’s say I want a page of my dashboard to always tell me how my company performed the exact same time last year. Thus shifting back date filters allows us to make helpful comparisons to our current performance.

You can shift back filters by as many years or quarters you want.

Example: I want the page to display how we were performing in this same quarter last year. To accomplish this, I first filter the data for This Quarter. I then shift the date back 1 year.

Shift back is selected in the filter