# Options list vizualization: some unique values of a field are missing in the dropdown list **URL:** \ **Category:** Kibana\ **Created:** [March 29, 2019, 12:01pm UTC](https://discuss.elastic.co/t/options-list-vizualization-some-unique-values-of-a-field-are-missing-in-the-dropdown-list/174529 "2019-03-29T12:01:37Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![metlovich97](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/metlovich97/32/43083_2.png) [@metlovich97](https://discuss.elastic.co/u/metlovich97)\ **Post date:** [March 29, 2019, 12:01pm UTC](https://discuss.elastic.co/t/options-list-vizualization-some-unique-values-of-a-field-are-missing-in-the-dropdown-list/174529/1 "2019-03-29T12:01:38Z")
In the dashboard I want to get statistics for a particular value of "analytics instance". However, when I finish typing it, I get the error as if I don't have documents with such a value. I know for certain that I do. Is it a Kibana bug or am I missing anything? Timeframes, index names, field names match. ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/3/f308b297de95f781dad906c374629aa8a2066df8.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/b/fb670248a9d5062417f379e1e1930246d13f438d.png) ---
**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\ **Post date:** [March 29, 2019, 9:21pm UTC](https://discuss.elastic.co/t/options-list-vizualization-some-unique-values-of-a-field-are-missing-in-the-dropdown-list/174529/2 "2019-03-29T21:21:33Z")
Hi, sorry for not recognizing this, but what application is in the top screenshot, and what kind of data is this? ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/9/7941527ff58698926fdba9ea86331d92dbe62809.png) Is it possible the field is mapped as analyzed text in Elasticsearch? For searches to match literal string matching, the field needs to be mapped as `keyword`. If there was not explicit mapping via a template or done at indexing time, the default mapping for the field could possibly be multi-field with text and keyword parts. ---
**Author:** ![metlovich97](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/metlovich97/32/43083_2.png) [@metlovich97](https://discuss.elastic.co/u/metlovich97)\ **Post date:** [April 1, 2019, 9:04am UTC](https://discuss.elastic.co/t/options-list-vizualization-some-unique-values-of-a-field-are-missing-in-the-dropdown-list/174529/3 "2019-04-01T09:04:48Z")
Hi! Yes, it's mapped as text with keyword. ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/b/db7b085041b88f589ce1a3429d743335dccbe388.png) Options vizualization uses keyword field and when I filter by this keyword field in Discover, I do get results: ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/b/2b87ee74831b65814752e5a8ec0dc95e2ed1ce2b.png) So I don't see any problem with the mapping. ---
**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\ **Post date:** [April 1, 2019, 6:14pm UTC](https://discuss.elastic.co/t/options-list-vizualization-some-unique-values-of-a-field-are-missing-in-the-dropdown-list/174529/4 "2019-04-01T18:14:19Z")
Hi, I'd just get the data mapped as plain `keyword` instead of multi-field. Text matching on a multi-field text field won't search the `.keyword` field by default. You don't need the analyzed text part, and having it there will cause a few instances of confusion. See: [https://www.elastic.co/guide/en/elasticsearch/reference/current/multi-fields.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/multi-fields.html) ---
**Author:** ![metlovich97](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/metlovich97/32/43083_2.png) [@metlovich97](https://discuss.elastic.co/u/metlovich97)\ **Post date:** [April 2, 2019, 1:09pm UTC](https://discuss.elastic.co/t/options-list-vizualization-some-unique-values-of-a-field-are-missing-in-the-dropdown-list/174529/5 "2019-04-02T13:09:30Z")
Nope, that doesn't work neither. Now the field mapping looks like: ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3a11a017e3e417970e487ac63f24e8355f673a7f.png) I can see the documents in Discover: ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/1/91974ba3f66169c5e5de92da56460424a4d70e40.png) but still not able to select this instance: ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/5/95d8b4554619db1431fb62be4ea554e8c2faf23f.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 30, 2019, 1:09pm UTC](https://discuss.elastic.co/t/options-list-vizualization-some-unique-values-of-a-field-are-missing-in-the-dropdown-list/174529/6 "2019-04-30T13:09:31Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.