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, and Ad Hoc Employee Research projects, although Lifecycle and Ad Hoc Employee Research 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

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

Removing Filters

  1. Select Edit Page to enable editing on your dashboard.
    Edit Page button
  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 Project Mapper 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