# Show document count per 1s with vertical bar chart

**URL:** <https://discuss.elastic.co/t/show-document-count-per-1s-with-vertical-bar-chart/71769>\
**Category:** Kibana\
**Created:** [January 16, 2017, 5:46pm UTC](https://discuss.elastic.co/t/show-document-count-per-1s-with-vertical-bar-chart/71769 "2017-01-16T17:46:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![erikanderson753](https://avatars.discourse-cdn.com/v4/letter/e/ecd19e/32.png) [@erikanderson753](https://discuss.elastic.co/u/erikanderson753)\
**Post date:** [January 16, 2017, 5:46pm UTC](https://discuss.elastic.co/t/show-document-count-per-1s-with-vertical-bar-chart/71769/1 "2017-01-16T17:46:40Z")

</div>

I am trying to show the document count per second with a vertical bar chart. I have it currently set up like this:

![](https://us1.discourse-cdn.com/elastic/original/2X/d/d10bc3189fce9846015e1e22d57a6dd05ff17549.png)

If I hover over the 'i' tooltip next to interval I get the following message:

![](https://us1.discourse-cdn.com/elastic/original/2X/7/79be2ec78ccdbe956ad508d9be5e7e4dde8feec3.png)

Previously in Kibana 3 there was the option to Transform Series to Seconds

 ![](https://us1.discourse-cdn.com/elastic/original/2X/3/36c7a7cac18e50ebe5e5f4659ec831707312abf4.png)

Is there any way that I can get a true per second count in Kibana 5?

---

<div class="post-metadata">

**Author:** ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)\
**Post date:** [January 16, 2017, 9:09pm UTC](https://discuss.elastic.co/t/show-document-count-per-1s-with-vertical-bar-chart/71769/2 "2017-01-16T21:09:14Z")

</div>

The scale chosen there is based on the `histogram:maxBars` advanced config setting. If you raise the limit to 3600 then you will get a true per/second count as long as your date range is less than or equal to an hour. Any more than an hour and it will keep scaling. Of course, you'll likely run out of pixels to render bars if you take it any higher than about 1000

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [January 17, 2017, 4:14am UTC](https://discuss.elastic.co/t/show-document-count-per-1s-with-vertical-bar-chart/71769/3 "2017-01-17T04:14:50Z")

</div>

Timelion might be able to do what you are looking for. It has a function named `scale_interval()`, which allows you to scale the value based on the with of the interval used in date histogram aggregations. If you e.g. are plotting request rate, you can display this as requests/second or requests/minute no matter what the aggregaten intervall is. This is tracked in the following [GitHub issue](https://github.com/elastic/kibana/issues/4646).

---

<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:** [February 14, 2017, 4:15am UTC](https://discuss.elastic.co/t/show-document-count-per-1s-with-vertical-bar-chart/71769/4 "2017-02-14T04:15:05Z")

</div>

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