Show document count per 1s with vertical bar chart

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

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

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

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

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

1 Like

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.

1 Like

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