# Interval is always calculated lower than expected (InfluxDB)

**URL:** <https://community.grafana.com/t/interval-is-always-calculated-lower-than-expected-influxdb/10498>\
**Category:** InfluxDB\
**Created:** [September 17, 2018, 7:24am UTC](https://community.grafana.com/t/interval-is-always-calculated-lower-than-expected-influxdb/10498 "2018-09-17T07:24:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kalidasya](https://avatars.discourse-cdn.com/v4/letter/k/4af34b/32.png) [@kalidasya](https://community.grafana.com/u/kalidasya)\
**Post date:** [September 17, 2018, 7:24am UTC](https://community.grafana.com/t/interval-is-always-calculated-lower-than-expected-influxdb/10498/1 "2018-09-17T07:24:35Z")

</div>

Hi,

I have two influxdb source both has the min interval setting set to 10s. This is our data insert interval.  
I have some graphs where the range is quite big, now-2d–now but the interval is calculated to 1m if I set it to -7d the interval changes to 5m.  
The problem is we have graphs with multiple queries and with this interval we hit the datapoint limit so not everything is plotted. I am not sure what is the expected resolution for a 2 day period or not. To me 1 min sounds a but too small. If it is unexpected any idea what can cause this? I tried the legacy interval and the new \_\_interval variables, I tried to override it from url (could not do it) but had no effect.

Thanks for the help

---

<div class="post-metadata">

**Author:** ![jangaraj](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/jangaraj/32/39197_2.png) [@jangaraj](https://community.grafana.com/u/jangaraj)\
**Post date:** [September 17, 2018, 7:38am UTC](https://community.grafana.com/t/interval-is-always-calculated-lower-than-expected-influxdb/10498/2 "2018-09-17T07:38:25Z")

</div>

There is no general expected resolution - it depends on the granularity of your data + probably you don’t want to kill browser with millions of datapoints in the graph visualization.

I recommend to create and use own interval dashboard variable for time aggregation and customize auto option there (if you want to use auto option - you can still select aggregation time manually):

 ![image](https://us1.discourse-cdn.com/grafana/original/2X/a/af82f31c188928e3eb1602d2bbbaf0b857723ce3.png)

---

<div class="post-metadata">

**Author:** ![kalidasya](https://avatars.discourse-cdn.com/v4/letter/k/4af34b/32.png) [@kalidasya](https://community.grafana.com/u/kalidasya)\
**Post date:** [September 17, 2018, 7:51am UTC](https://community.grafana.com/t/interval-is-always-calculated-lower-than-expected-influxdb/10498/3 "2018-09-17T07:51:12Z")

</div>

Thank you for your help, I will check this out