Grafana dashboards not working for long range queries

[jangaraj]

It depends. Time aggregation is not downsampling. You can still have raw data if you need them. that’s not possible with downsampling.

BTW:

Aggregation issues

Grafana has “magic” variable $__interval, which calculates aggregation period based on current dashboard time range automatically. But you can define time groupping period explicitly. So if you need 1d, then: SELECT sum("field") FROM measurement WHERE $timeFilter GROUP BY time(1d) You can also create own dashboard variable (Type: Interval) and define own aggregation periods there + custom auto value as well and then you can use it in GROUP BY time($mycustomaggregationvariable).