# Logarithmic date histogram

**URL:** <https://discuss.elastic.co/t/logarithmic-date-histogram/95475>\
**Category:** Kibana\
**Created:** [August 2, 2017, 8:19am UTC](https://discuss.elastic.co/t/logarithmic-date-histogram/95475 "2017-08-02T08:19:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![raisinpit](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@raisinpit](https://discuss.elastic.co/u/raisinpit)\
**Post date:** [August 2, 2017, 8:19am UTC](https://discuss.elastic.co/t/logarithmic-date-histogram/95475/1 "2017-08-02T08:19:51Z")

</div>

Hi,

I've been working with the date histogram visualization, I want to display only the days that have a value of 1 or higher because that will allow me to use the logarithmic I believe.

I worked out this query in the Dev Tools tab:  
{  
"size": 0,  
"aggregations" : {  
"dates" : {  
"date\_histogram" : {  
"field" : "Message\_CreationTime",  
"interval": "day",  
"min\_doc\_count": 1  
}  
}  
}  
}  
It returns exactly what I want however when I go into the visualization I still get the days that have a document count of less than 1.  
I hope somebody could point out some mistake I made.  
I'm using the 5.4 version of the Elastic Stack.

---

<div class="post-metadata">

**Author:** ![raisinpit](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@raisinpit](https://discuss.elastic.co/u/raisinpit)\
**Post date:** [August 2, 2017, 8:41am UTC](https://discuss.elastic.co/t/logarithmic-date-histogram/95475/2 "2017-08-02T08:41:00Z")

</div>

Some extra information: I'm working with the BarChart and have 2 days in a span of a month without values. I'd also like to split the bar if that is possible to achieve with the logarithmic y-axis.

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [August 2, 2017, 4:42pm UTC](https://discuss.elastic.co/t/logarithmic-date-histogram/95475/3 "2017-08-02T16:42:49Z")

</div>

Unfortunately it seems there's a bug at the moment. You can follow this issue for updates: [https://github.com/elastic/kibana/issues/11723](https://github.com/elastic/kibana/issues/11723)

---

<div class="post-metadata">

**Author:** ![raisinpit](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@raisinpit](https://discuss.elastic.co/u/raisinpit)\
**Post date:** [August 3, 2017, 2:19pm UTC](https://discuss.elastic.co/t/logarithmic-date-histogram/95475/4 "2017-08-03T14:19:31Z")

</div>

Thanks for the info Lukas. I will use a different visualization then.

---

<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:** [August 31, 2017, 2:19pm UTC](https://discuss.elastic.co/t/logarithmic-date-histogram/95475/5 "2017-08-31T14:19:33Z")

</div>

Closed on August 31, 2017, 2:19pm UTC

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