Filtering data

Use filters to limit the data you are viewing to items of interest.

Filters are a way to reduce or narrow down the results returned by a query based on specific criteria. You can base a filter on any field in the field picker.

You also don't need to add a dimension or measure to your results to filter on it. For example, you can create a query that filters the Completed Date to the last 30 days, even though your results only show NPS®¹ Category and Region.

Filtering occurs at different times for dimensions and measures:

• When you filter on a dimension, you restrict the results from the query before any calculations are made.
• When you filter on a measure, you restrict the results after calculating measures.

You can use any combination of the available filter types in your query:

• Basic Filters: You are able to specify the filter settings from drop-down lists, calendar widgets, and text boxes.
• Advanced Matches: You are able to specify more advanced conditions for a filter, such as specific text searches, or a date range that starts in the past and extends a certain number of days.

  Filter expressions are an advanced way to filter queries. Use this type of filter by choosing the matches (advanced) option.

  

  For information on the filter expressions you can use, see Filter expressions.

• Custom Filters: You are able to specify detailed business logic, combine AND and OR logic, and use functions.

• Adding a basic filter
  Use basic filters to select filter conditions from predefined drop-down lists.
• Adding an advanced match filters
  Use advanced match filters to create complex filters, using filter expressions, that cannot easily be expressed using basic filters.
• Adding a custom filter
  Use custom filters when you need to add advanced business logic to a filter.
• Exclude null values from a visualization tile
  You can remove null values by adding filters to a visualization's dimensions or measures.
• Filter expressions
  Filter expressions are an advanced way to write filter queries.

¹ Net Promoter, NPS, and the NPS-related emoticons are registered U.S. trademarks, and Net Promoter Score and Net Promoter System are service marks, of Bain & Company, Inc., NICE Systems, Inc. and Fred Reichheld.