# Kibana visualization showing data as "Other" **URL:** \ **Category:** Kibana\ **Created:** [August 27, 2021, 6:47am UTC](https://discuss.elastic.co/t/kibana-visualization-showing-data-as-other/282636 "2021-08-27T06:47:37Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![online](https://avatars.discourse-cdn.com/v4/letter/o/bb73d2/32.png) [@online](https://discuss.elastic.co/u/online)\ **Post date:** [August 27, 2021, 6:47am UTC](https://discuss.elastic.co/t/kibana-visualization-showing-data-as-other/282636/1 "2021-08-27T06:47:37Z")
Hello Guys, I am having an issue where some of the data on visualizations including in tables/dashboards appear as "Other". The index that holds this data have no data with that particular word. What could be the reason for this anomaly? When I removed them via the include/exclude icons it goes and create a filter with those lines. In those lines I could see the actual data it has replaced with the word "Other". I tried to find any pattern in data like null values or similar for this issue to occur but found nothing. Thank you for your time and answers. ---
**Author:** ![online](https://avatars.discourse-cdn.com/v4/letter/o/bb73d2/32.png) [@online](https://discuss.elastic.co/u/online)\ **Post date:** [August 30, 2021, 2:31am UTC](https://discuss.elastic.co/t/kibana-visualization-showing-data-as-other/282636/2 "2021-08-30T02:31:57Z")
Answer to this one lies in the Kibana designers Top Values settings. The maximum is 100. So anything more than that it seems to identify as "Other". ---
**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\ **Post date:** [August 30, 2021, 4:33am UTC](https://discuss.elastic.co/t/kibana-visualization-showing-data-as-other/282636/3 "2021-08-30T04:33:54Z")
Yes, thats right . The max number is 100. The reason we limit them is that the tables are built using aggregations (same as any other visualization). Elasticsearch has a limit on the number of buckets it can work with for each query ([read the docs about `search.max_buckets`](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-settings.html#search-settings-max-buckets)). For an open control of that number of values, you can try the visualization called Data Table (under Visualizations \> Create). It allows you to enter any number (although the same ES max\_buckets limitation still applies). Rest of them are identified as other. Thanks Rashmi ---
**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\ **Post date:** [August 30, 2021, 4:43am UTC](https://discuss.elastic.co/t/kibana-visualization-showing-data-as-other/282636/4 "2021-08-30T04:43:46Z")
Hi @online As you can see we are not all guys 🙂 Interesting there has been an update... As of 7.14 The lens table now supports 1000 rows for Top N, today there is no a visualization with infinite rows. We just had a conversation about this in [this thread](https://discuss.elastic.co/t/kibana-is-helpful-but-interface-is-very-horrible/281117/2) ---
**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\ **Post date:** [August 30, 2021, 4:45am UTC](https://discuss.elastic.co/t/kibana-visualization-showing-data-as-other/282636/5 "2021-08-30T04:45:57Z")
That's interesting to know. Thanks you for updating @stephenb ---
**Author:** ![online](https://avatars.discourse-cdn.com/v4/letter/o/bb73d2/32.png) [@online](https://discuss.elastic.co/u/online)\ **Post date:** [August 31, 2021, 1:00am UTC](https://discuss.elastic.co/t/kibana-visualization-showing-data-as-other/282636/6 "2021-08-31T01:00:19Z")
Thanks @stephenb, Appreciates your reply and and noted. Cheers. ---
**Author:** ![online](https://avatars.discourse-cdn.com/v4/letter/o/bb73d2/32.png) [@online](https://discuss.elastic.co/u/online)\ **Post date:** [August 31, 2021, 1:01am UTC](https://discuss.elastic.co/t/kibana-visualization-showing-data-as-other/282636/7 "2021-08-31T01:01:11Z")
Thanks @rashmi, Appreciates your reply and and noted. Cheers. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 28, 2021, 1:02am UTC](https://discuss.elastic.co/t/kibana-visualization-showing-data-as-other/282636/8 "2021-09-28T01:02:00Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.