# "Group other values in separate bucket" Option does not work in bar graphs

**URL:** <https://discuss.elastic.co/t/group-other-values-in-separate-bucket-option-does-not-work-in-bar-graphs/135170>\
**Category:** Kibana\
**Created:** [June 8, 2018, 2:30pm UTC](https://discuss.elastic.co/t/group-other-values-in-separate-bucket-option-does-not-work-in-bar-graphs/135170 "2018-06-08T14:30:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rjain](https://avatars.discourse-cdn.com/v4/letter/r/5f9b8f/32.png) [@rjain](https://discuss.elastic.co/u/rjain)\
**Post date:** [June 8, 2018, 2:30pm UTC](https://discuss.elastic.co/t/group-other-values-in-separate-bucket-option-does-not-work-in-bar-graphs/135170/1 "2018-06-08T14:30:40Z")

</div>

I have created a bar graph that splits each bar (series) to show the 5 top frequently used items. However, when since I want all the other items to be shown in an "others" bucket, I clicked on the "Group other values in separate bucket" option. However, there is no change in the graph and only 5 buckets appear.

Could you please help me with the issue?

---

<div class="post-metadata">

**Author:** ![jen-huang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jen-huang/32/74327_2.png) [@jen-huang](https://discuss.elastic.co/u/jen-huang)\
**Post date:** [June 8, 2018, 5:10pm UTC](https://discuss.elastic.co/t/group-other-values-in-separate-bucket-option-does-not-work-in-bar-graphs/135170/2 "2018-06-08T17:10:14Z")

</div>

Is it possible that your data for that field doesn't have more than 5 distinct values? The "Other" bucket will not show if the count of other values is 0.

You can check the distinct values of a field by running a query like this in Console, where `logstash-*` is your index pattern, and `machine.os.keyword` is your field:

```auto
GET logstash-*/_search
{
  "size": "0",
  "aggs": {
    "uniq_values": {
      "terms": {
        "field": "machine.os.keyword"
      }
    }
  }
}

```

---

<div class="post-metadata">

**Author:** ![rjain](https://avatars.discourse-cdn.com/v4/letter/r/5f9b8f/32.png) [@rjain](https://discuss.elastic.co/u/rjain)\
**Post date:** [June 11, 2018, 2:49am UTC](https://discuss.elastic.co/t/group-other-values-in-separate-bucket-option-does-not-work-in-bar-graphs/135170/3 "2018-06-11T02:49:19Z")

</div>

Thanks for the reply!

No, my data has about a 1000 values each. I think I may have found a bug as if I place split chart in the end of my aggregations list, the other bucket shows, while if I place the split chart at the top, the others bucket does not show up.

I am sure that the data is pruned as the total length of the bars in the graph is reduced @jen-huang.

---

<div class="post-metadata">

**Author:** ![jen-huang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jen-huang/32/74327_2.png) [@jen-huang](https://discuss.elastic.co/u/jen-huang)\
**Post date:** [June 27, 2018, 5:28pm UTC](https://discuss.elastic.co/t/group-other-values-in-separate-bucket-option-does-not-work-in-bar-graphs/135170/4 "2018-06-27T17:28:52Z")

</div>

That sounds like it could be a valid bug, you can open a Github issue with details: [https://github.com/elastic/kibana/issues](https://github.com/elastic/kibana/issues)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 25, 2018, 5:42pm UTC](https://discuss.elastic.co/t/group-other-values-in-separate-bucket-option-does-not-work-in-bar-graphs/135170/5 "2018-07-25T17:42:37Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.