Likely Causes
If you’re not seeing some values pop up as suggestions on a filter, the two most likely causes are that the suggestions are being filtered due to faceted filtering, or that the value is new and your suggestions are from an old cached value.
Clearing Cached Suggestions
To clear cached filter suggestions, click into the filter dialog box then hold down command + shift on a Mac or ctrl + shift on Windows/Linux and a button to refresh the suggestions will pop up.
Filter Faceting
If you’re not seeing some values pop up as suggestions on a filter, it’s likely that faceted filtering is at play. By default, filters “facet” each other, which means they limit other filter options to show only the values that are possible when the other filters are applied. Filters will always be faceted regardless of the order they appear in on your dashboard or workbook.
Disabling Filter Faceting on Dashboards
Filter faceting is enabled by default, but if you would like to turn it off for a dashboard, go to Edit > Settings, and then toggle off “Enable facet filters”.
Understanding more about filter faceting
As a simple example, imagine a table of orders for an e-commerce business, where orders take at least 2 days to ship. If you filter for only the orders with a Created Date
in the past 1 day, then none of them will have a Status
of “Shipped”, so “Shipped” won’t show up as a possible filter option:
While Omni will limit the suggested filter values, you can always manually input a filter value:
Omni will also take into account default dashboard filters when faceting. If you’re still not seeing expected filter suggestions on a dashboard, check to see if you have any default dashboard filters that are causing suggested values to be faceted out.