Filter Your Data

Modified on Fri, 6 Nov at 12:59 PM

Analyze

Filtering narrows your results down to one group of people, like a single business unit, age range, or manager's team, so you can see how that group answered.

 

You can filter results in Advanced Reporting for Point-In-Time, Lifecycle, and 360 feedback events. You build a filter by picking from your event's demographics, and you can combine as many as you like. Crowdsource events work a little differently, using Compare Results instead. That's covered at the end.

A few things worth knowing before you start:

  • Once you apply a filter, it stays on as you move between reports, until you clear it.
  • The demographics you see in the list depend on the access your organization has given you.
  • Filtering never shows results for a group too small to meet your event's minimum response threshold. More on that below.

Which filter window you'll see

Advanced Reporting has two versions of the filter window, and the one you get depends on how your event's reporting is set up. Both do the same job. You'll know which one you have as soon as you open it:

  • The newer window is split into two columns. Demographics are listed on the left, their options show up on the right, and the button at the bottom says Apply Filters. Most of this article covers this one.
  • The original window has a single Select a demographic dropdown and buttons labeled Further Refine Filter and Submit Filter. Jump to Using the original filter window if that's what you see.

Saving, clearing, and reusing filters work the same way with either window.

Creating a filter

  1. Open Advanced Reporting for your event.
  2. Click Filter Data on the right side of the filter bar, then click New Filter.

  1. The New Filter window opens. On the left is Select a Demographic, a list of every demographic you can filter by. The right side stays empty until you pick one.

  1. Click a demographic. Its options appear on the right, each with a number next to it (for example, N=1565) showing how many people who responded fall into that option. Tick the ones you want. Select All and Clear All at the top of the column save you some clicking.

  1. To add another demographic, click it on the left and tick its options. The numbers beside each option update to account for what you've already picked, so you can see how big the group is before you apply anything. Any demographic you've picked from shows a small count badge in the list.
  2. Check the Selected panel at the bottom. It lists everything you've picked, grouped by demographic, and Population Selected shows how many people your filter includes. Click the X on any option to remove it, or click Clear to start over.

  1. Click Apply Filters.

Your reports refresh to show only the people in your filter. The filter bar at the top now says Filter, shows the new count, and spells out what you picked. To change it, click (edit) next to your filter, and the window reopens with your picks still in place.

Search instead of scrolling

Long list? Both columns have a Search box. Type in the left one to find a demographic, or in the right one to find an option inside the demographic you're looking at. The list narrows as you type.

Filtering by manager

If your event uses a manager hierarchy, you'll find Manager Hierarchy in the demographic list. Its options show up as an org chart you can expand with the arrows. The number next to each manager counts everyone in their part of the organization, not only their direct reports.

How your picks combine

The window follows two simple rules:

  • Options inside one demographic add up. Tick two business units and your filter includes people in either one.
  • Different demographics narrow things down. Pick a business unit and an age range and your filter includes only people who match both.

Example

Ticking Corporate and Field under Business Unit gives you everyone in either unit. Adding 25-34 years under Age (Range) then trims that down to people in either unit who are also 25 to 34.

When a group is too small

Results are only shown for groups that meet your event's minimum response threshold, which keeps individual answers private. The filter window tells you up front when something falls short:

  • An option that's too small on its own shows Too few to display instead of a number.
  • If your picks add up to a group that's too small, Population Selected also says Too few to display, and Apply Filters is unavailable until you remove something.

Some events also use exclusion rule filtering, which checks that the people you didn't pick are a big enough group too. If your filter would leave too small a group behind, the window shows a message explaining why it can't be applied. Exclusion Rule Filtering explains how that works.

Saving a filter

If you'll want the same filter again, save it once it's applied.

  1. Click Filter Data, then Save Filter.
  2. Type a name in the Name of the filter box.
  3. Click Save.

Using a saved filter

  1. Click Filter Data, then Retrieve Saved Filter. The Saved Filters window lists the filters you've saved.
  2. Click Load next to the one you want.

Retrieve Saved Filter is only available once you've saved at least one filter.

Clearing a filter

Click Clear Filter in the filter bar, or click Filter Data and then Clear Filter. Your reports go back to showing everyone.

Note

A filter stays on as you move from report to report. If numbers look smaller than you expect, glance at the filter bar. If it says Filter rather than your organization's name, a filter is still applied.

Using the original filter window

If your filter window has a single dropdown instead of two columns, here's how it works.

  1. Click Filter Data, then New Filter.
  2. Open the Select a demographic dropdown and choose a demographic.
  3. Tick the options you want. The window shows how many people are in each one.
  4. To add another demographic, click Further Refine Filter and pick again. Your filter then only includes people who match both. Some events also have an Expand Filter button, which includes people who match either one instead.
  5. If the count drops too low, the window tells you there are too few respondents to show, and you'll need to change your picks.
  6. Click Submit Filter.

Compare Results for Crowdsource events

Crowdsource events don't use Filter Data. Instead, you break results down with Compare Results, using the employee tags set up for the event.

  1. Click Compare Results.
  2. Open a demographic dropdown and choose an option. Repeat for any other demographics you want.
  3. Click Apply.

The Compare Results panel on a Crowdsource event summary, with dropdowns for departments, locations, tenures, and company, and Cancel and Apply buttons

Results for the group you picked show up underneath the overall results for each item.

A Crowdsource event summary with results for the Finance group shown beneath the overall result for each item

To go back to everyone, click Compare Results, click Reset at the top right, then click Apply.

What's next

Filter applied? The Favorability Report is a good place to see how your group answered each question.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article