Grafana max number of data points for display

Grafana Dashboards
1

Hi All
I use Grafana to display 5 minute sensor data. Over 1 day the data visualises as expected. If the period is increased to say 1 month then I get the following error

A query returned too many data points and the results have been truncated at 4521 points to prevent memory issues. At the current graph size, Grafana can only draw 452.

I have added aggregateWindow as per following which corrects the issue and the data displays correctly for the longer period but when I go back to 1 day time period the data is truncated and not as visaully appealing as without the aggreegateWindow function

from(bucket: "home")
  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)
  |> filter(fn: (r) => r._field == "SOC")
  |> aggregateWindow(every: v.windowPeriod, fn: mean)

Outputs with and without

image

image

Is there anyway to make this more dynamic based on the time period?

2

Hi @davidmartin1408,

Not sure but did you try the Query option where you can change the max data points?

Here is a reference screenshot:

image
image1520×668 58 KB

Let us know if this helps.

3

Hi @davidmartin1408

Did you find a solution or is this is still on-going?

We would like to know the updated status :slight_smile:

Thanks

4

All good as per your advise. Thanks