# Why count in my line chart shows incorrect value before drill down?

**URL:** <https://discuss.elastic.co/t/why-count-in-my-line-chart-shows-incorrect-value-before-drill-down/81911>\
**Category:** Kibana\
**Created:** [April 11, 2017, 4:56am UTC](https://discuss.elastic.co/t/why-count-in-my-line-chart-shows-incorrect-value-before-drill-down/81911 "2017-04-11T04:56:47Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [April 11, 2017, 5:15am UTC](https://discuss.elastic.co/t/why-count-in-my-line-chart-shows-incorrect-value-before-drill-down/81911/2 "2017-04-11T05:15:56Z")

</div>

Setting a 1 second interval for an aggregation across a long time range will generate a very large number of buckets. I suspect Kibana therefore alters the interval automatically. You should be able to check this by looking at the generated aggregation, which can be seen by expanding the statistics view in the lower left corner of the visualisation.

If you are looking for a graph showing per second request rate, I would recommend creating a Timelion sheet that uses the `scale_interval` function (similar to [this thread](https://discuss.elastic.co/t/how-to-find-bandwidth-usage-from-netflow-data/62005/8)). As Timelion is now part of core Kibana, you can add Timelion sheets to a dashboard.

---

_[View the full topic](https://discuss.elastic.co/t/why-count-in-my-line-chart-shows-incorrect-value-before-drill-down/81911)._