Add option to not show empty buckets in Histogram

[LeeDr]

Describe the feature: Reference #5665

There is a checkbox "Show empty buckets" but regardless of that checkbox, the X-Axis still shows all the intervals even if they are empty buckets. There are cases where users don't want empty buckets to show in the chart.

• One option would be to use the existing checkbox for both the query and the charting.
  • So leaving it unchecked would query with min_doc_count: 1 and would NOT show the empty buckets on the chart.
  • Checking the box would use min_doc_count: 0 and WOULD show the empty buckets on the chart.
    But I'm not sure we even need to use min_doc_count: 0 since we're currently showing the empty buckets on the chart in both cases? Adding min_doc_count: 0 can take up a lot of memory on Elasticsearch and even run it out of memory in some cases.
• But this option changes charts for existing users.
• Another option would be to have 2 checkboxes. One that controls min_doc_count and the other that controls the charting.
  • Are these 2 checkboxes completely independent? Or can you only check one if the other is checked?
  • Maybe I don't want to bother Elasticsearch with returning empty buckets but I do want to show them on my chart (like current behavior with "Show empty buckets" unchecked.
  • I can't think of a case where we need Elasticsearch to return the empty buckets if apparently we can chart them without those buckets.

[khelmrab]

Hello @thomasneirynck, @spalger,
I use the version 5.4 of kibana with aggregation with range don't display the empty buckets, and it's work in version 5.6.3 in my case i can't upgrade my version so I investigate to see the difference between the different code but I didn't find that !! so it's possible to oriented me to know what I can add to make the empty bucket display work in the Range aggregation in my current version 5.4
Best regards

[stratoula]

This is already possible in Lens with the hide empty values switch