Skip to main content
Each dimension can be added as a filter to focus on specific rows of data. Different filtering options will be presented for dates, numbers, and strings: To filter using more than one value (equivalent to using OR), insert a comma between values: [bread, cheese]. If your filter values include commas, you can escape them with \: San Francisco\, CA.

​
Date filters

Filter suggestions are limited to 2,000 rows.
Date filtering offers several filter options, including:
  • Absolute date filtering, such as 2022, 2023-01-01, 2021-Q4
  • Relative date filtering, such as after 7 complete days ago, 1 year ago
At times, filtering may require using both absolute and relative dates, for example first ten days of 2023 or 100 days ago for 10 days. For these situations, time for an interval duration offers more flexible time inputs:
  • The first input should contain the starting point. This value should either be a date (2023-01-01) or a relative date (10 days ago). Note: Ago is required.
  • The second input should contain the duration.
Check out the following examples to see how it all comes together: 
# First ten days of 2023
[2023][10 days]
# 100 days ago for 10 days 
[100 complete days ago][10 days]
# 1 hour ago for 2000 milliseconds
[1 hour ago][2000 milliseconds]

​
Interval timeframe units

Intervals can accept any timeframe unit:
Interval typeSupported units
dayday, days, complete day, complete days
weekweek, weeks, complete week, complete weeks
monthmonth, months, complete month, complete months
quarterquarter, quarters, complete quarter, complete quarters
yearyear, years, complete year, complete years
millisecondmillisecond, milliseconds, complete millisecond, complete milliseconds
secondsecond, seconds, complete second, complete seconds
minuteminutes, complete minute, complete minutes
hourhour, hours, complete hour, complete hours

​
Filtering by another query

With two or more tabs, one tab, or query, can be used as a filter in other queries. This is particularly useful for creating a dynamic subset of information in one query and a deep dive into the results on another tab. For example, you want to understand the brands your top customers are purchasing. To do this, you would:
  1. In a workbook, create a tab with the definition of a top customer.
  2. Create a new tab.
  3. In the new tab, add the dimensions and measures you want to analyze.
  4. In the field picker, locate a dimension used in the top customer definition tab.
  5. On the dimension, click the options menu (three dots) and select Filter.
  6. Select Is from another query.
  7. In the modal that displays, select the tab and dimension you want to filter by:
This will filter the tab results by the selected subset. In SQL, this generates WHERE clauses that look like WHERE IN (SELECT...) where the SELECT clause is the filtering query.
You can also use this approach to filter out data. To do this, select Is not from another query in the Filter menu or the field_name_not_in_query filter parameter.

​
Filtering by multiple conditions

You can filter a field by multiple conditions (e.g. Date is in the past 30 days OR date is null) by clicking Add Condition in the filter modal. Then, select if you want All or Any of the conditions to apply to the query.

​
Filter suggestions

Filter suggestions are populated by running a sql query to return unique values for the field being filtered on, in the context of the Topic it is in, with the exception being if any of the following parameters are in use: suggest_from, suggest_from_topic, or suggestion_list. The general format is: 
  SELECT field_filter_is_based_on
    FROM table
GROUP BY 1
   LIMIT 2000
Depending on the specifics of the model (such as if this field is in a table other than the base view of a Topic) you may see the relevant JOIN or WHERE clause statements in the suggestion query. The limit of 2000 is not configurable.

​
Refreshing filter suggestions

In rare circumstances, filter suggestions may be cached in a stale state. To enable the refresh option:
  • Mac - Hold Command + Shift
  • Windows - Hold Windows + Shift
Note: The refresh option only clears suggestions for the specific query, not all filter suggestions. More troubleshooting tips can be found here

​
Adding dashboard filters to workbook queries

This feature is not available in raw SQL mode or on read-only/linked tabs.
When editing a workbook tab that’s backed by a dashboard with filters, you can quickly add dashboard-level filters to your workbook query using the Filters from dashboard dropdown. Click the Filters from dashboard dropdown located in the query tab’s filter bar to see applicable dashboard filters. Values and settings from the dashboard are preserved when a filter is added. If you don’t see a filter you expect to, keep in mind that Omni excludes:
  • Filters already present on the query
  • Filters whose fields are covered by existing controls
  • Hidden filters
  • Cross-topic filters (filters that don’t match the tab’s topic)
  • Dashboard controls