I have a column specified as "Text", containing some ID in integer form with 14 digits, (e.g. 12345678912340).
For those keys I have 622 distinct values for which I now want to filter-in one of those.
When I click on the column and select "Filter" in "Explore" view and tick the corresponding value, nothing happens. To cross check, I selected another column with a similar structure ("Text" consisting of integer values), but with only 3 digits (e.g. 123). There, filtering works as expected. Is this a technical issue or am I missing something here?
Edit: Here are Screenshots of both cases:
Non-Working (nothing happens on ticking 3007207....; notice "All" at the filter above the selection):
Counter-Example for working filter (after ticking "281", the table gets refreshed, column header turns blue + filter symbol appears and only rows with the value matching the filtering condition are shown):
Thanks in advance!
The list view of the filter on the Explore screen of a Dataset contains a sample of the distinct values. Since you have many distinct values, the one you are looking for may not appear.
In order to filter for one specific value, I advise to use the "text" view of the filter, as shown below:
Hope it helps,