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

Advanced Dashboard Filters (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. For more details on each, see Types of Employee Experience Projects.

About Advanced Dashboard Filters

The way standard dashboard filters work is that every new field is joined by “and,” but multiple values of the same field are joined by “or.” For example, if I filter for two marital statuses (married, single) and one employment status (unemployed), all the results must include respondents who are unemployed, but they can be married or single.

However, sometimes you will want to filter your data in ways that are more complicated that this. Advanced Filters are a great way to narrow down your data to the most specific requirement.

Advanced filters can be added to a page or widget.

Qtip: When applied on the page level, Advanced Filters always apply and are not overridden by widget-level filters. This behavior is different than other page filters, which will be overridden by any widget-level filters.

Adding Advanced Filters

  1. Click Edit Page to put the dashboard in edit mode.
    Edit Page button on the upper-right of the dashboard
  2. Click Add Filter.
    Add Filter in middle of menu with Advanced Filter at the top
  3. Select Advanced Filter at the top.
  4. Label the filter. If you do not fill out this field, the filter will become a combination of all the fields included.
    Advanced Filter window
  5. Click Insert New Condition to start defining the conditions under which data is included in the dashboard page.
  6. In the first field, decide what kind of information you’d like to filter by.
    A filter with a completed condition
  7. Fill out the following fields according to your desired filter.
  8. If desired, click Insert New Condition Set to nest a new filter beneath the first one.
    Qtip: Read the All & Any Sets and Condition Sets sections for more details.
  9. When you’re done, click Save Filter.

Fields You Can Filter By

Every field type interacts a little differently with Advanced Filters.

  • GenericValue: Text Value fields. You can compare a value by “doesn’t / equal(s),” “doesn’t / contain(s),” and “is / is not empty.”
    What is your zip code? Equals 90210
    When filling out a value in the open-ended field:

    • All terms in the field will be found. For example, typing “All” will also return answers containing “Tall” and “Tally.”
    • Do not use quotes.
    • Spaces are ignored.
  • EnumerableValue: Text Set fields. You can specify a value by whether it “is / is not,” “is / is not empty,” and whether it “includes / doesn’t include” the selected values.
    Department is Human Resources

    • Values can “include” multiple choices that will be treated as if joined by “or.” (E.g., “includes married, single” will return both married and single results.)
    • “Doesn’t include” searches joins results by an “and.” E.g., “doesn’t include married, single” with exclude married results AND single results.
  • EnumerableValueSet: Multi-Answer Text Set fields. You can specify a value by whether it “is / is not empty,” whether it “includes / doesn’t include” the selected values, or whether it “exclusively is” the selected value. If you use “exclusively is” and have more than one value selected, the data must contain BOTH values to be included. This is useful for filtering multiple select questions.
  • EnumerableScalarValue: Number Set fields. Use numeric comparisons like “greater than,” “less than,” equal to,” etc.
    It is easy to collaborate with other functions or teams in this company equals 7
  • ScalarValue: Numeric fields. Use numeric comparisons like “greater than,” “less than,” equal to,” etc.
  • DateTime: Date fields. Select from a series of time conventions, such as “before” a date, “after,” “between,” or from within a dynamic, preset amount of time. For example, “Last 14 Days” will adjust so as to always be the last 14 days’ worth of data, not 14 days from the time of adding the filter.
    Metadata Start Date is before Jun 15 2018
    You can also filter “within the last” amount of days, weeks, months, quarters, or years. From there you can “Shift back” the date range.
    Data for this quarter, shift back is selected and set to 1 year
  • Id: The Data Set Source or Person ID. Here, you can specify a value by whether it “is / is not,” “is / is not empty,” and whether it “includes / doesn’t include” the selected values.
    Data set source includes engagement survey 2018
    Values include:

    • All responses
    • Specific sources that are mapped. For example, if you have three surveys mapped, you can select data from just the one instead.

All & Any Sets

You add statements to your condition by clicking Insert New Condition.

Green Insert New Condition button adds another statement beneath the first, indented on the same level

Whenever you have more than one condition, you’ll need to decide how the conditions are connected to each other. Do both conditions need to be met (e.g., a response must be from a particular month AND for a specific manager to be included)? Or does only one of the conditions need to be true (e.g., data may be included in the report if it was collected either in the Northeast OR the Southeast)?

Conditions linked by an AND conjunction are called ALL condition sets (i.e., “only show data where ALL of these conditions are true”). Conditions linked by an OR conjunction are called ANY condition sets (i.e., “only show data where ANY of these conditions are true”).

Example: Look at the following screenshot. Because “All of the following must be true” is being used, this filter will capture everyone with a high attrition risk who ALSO scored very high on their performance ratings. Employees who performed highly but don’t have a risk of attrition, and employees who are a high risk of attrition but did not perform highly, will not be included.

Condition Sets

Conditions within the same Condition Set are all indented the same amount and are beneath the same ALL/ANY header.

Two different condition sets marked in red to show they are indented the same

You can create new condition groups by clicking Insert New Condition Set. This will nest a new condition set under the condition set you’re currently working on.

Insert new condition set button in green

At any point, you can delete an entire condition set by hovering over the ANY/ALL header and clicking the minus sign (). Note that this deletes all conditions nested underneath, including additional condition sets!

Minus sign next to Any dropdown

Nesting Logic

Nesting condition sets allows you to create more advanced criteria to filter your data by.

A advanced filter with multiple sets

This report will only include responses from employees who have a high attrition risk and high performance rating, who are either located in the USA (country) or sell to North America (region).

In the above example, the very outermost group is an ALL group. Employees must be BOTH high performing AND at high risk of attrition. Nested under that ALL group is an ANY group. After meeting the performance rating and attrition risk criteria, employees must EITHER have a country of USA, OR they must have North America as their region.

Essentially, you’ll make a new condition set every time you want to switch from an ANY to an ALL (and vice versa).

With this structure, it is therefore very important to consider which type of group (ALL or ANY) is your very outermost group before you start adding conditions and nesting. The question to ask is whether, at the highest level, you are looking for responses that meet all necessary conditions (ALL group) or are you looking for responses that meet one or more of possible conditions (ANY group).

3 line icons next to left of conditions and sets

To change the order in which conditions or groups appear, hover over that condition or group, click the icon, and drag. Note that you can only reorder items nested on the same level – you cannot use this function to nest items differently!

Nesting Basics

  • Clicking New Condition will add a new statement within the same condition set.
  • Clicking New Condition Set will nest a new condition set under the one you’re working on.
  • Click the minus sign () next to a condition or condition set to delete it.
  • Clicking the minus sign () to the right of a condition set’s header will delete the whole group and everything inside it, so be careful!
  • You cannot add items a level above. You can only add them a level below and reorder within a level.

Using Advanced Filters

Once you add an advanced filter to the dashboard, all users will have it available to them.

Users are allowed to change how the filter appears to them, only, by adding new conditions and condition sets.

Qtip: You can prevent users from modifying the filter at all by selecting Lock filter when you create it.

Lock Filter option in upper-right

Removing Advanced Filters

If you have editing access to filters, you can remove the advanced filter by clicking it and selecting Remove Filter.

Opening filter reveals a Remove filter button on the lower-left