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.
More Niche Scenarios
If clearing cache and checking filter faceting doesn’t reveal the issue you may need to dive deeper and look at the actual sql query that is being run to get the filter suggestion values.
To do this you’ll need to open your browser’s network console:
- open network console (cmd+option+i for mac or F12 or ctrl+shift+i for Windows on chrome)
- click into the filter for network activity and enter “suggestions”
- click on the suggestions? request
- select response
- look for “display_sql”
Just like any other query, the ability to run a filter suggestion query is subject to having the appropriate conditions so if the issue is with restricted querier/viewer users only then it’s possible the filter suggestions are coming from a field that is not inside a Shared Model topic
If this is the case, you will see “Failed to plan query” in the suggestion query display sql you find in the network tab.
If you see an actual sql query, you can copy that and put it into a sql tab of a workbook and start examining why the results aren’t as expected. It could be some topic level filtering or user attributes in an always_where_sql for example or some row level access filtering.
If you’re really stuck, reach out to support!