Visualization Panels and Aggregation

Grafana Dashboards
1

So here is a question that I am guessing there is a very simple answer to that i am just missing.

I have a panel that shows data based on current metric value, previous 1m, and previous 2m (using offset). I have a query that shows a marker when the current value is above the previous 2 values (meaning rising for 3 minutes). This works well when i am looking at up to the last 2 days, but when i change to 7 or 30 days, i believe grafana is using a different aggregation interval and i dont see my marker (as well my averages shown drop dramatically). Again, i suspect this is because when showing longer intervals grafana is using a different aggregation, which i suspect is quite normal. I guess my question is then that i want to visual 30 days of data but at the same granularity as when i am showing 1 hour?

2

Is it really good idea?

Let’s say you have graph with 1000px width:

  • 1 hours with 1min aggregation → you need to visualise 60 data points on 1000px - no problem
  • 30 days with 1min aggregation → you need to visualise 43200 (30x24x60) datapoints on 1000px → possible but you need monitor with 44k pixels, so actually impossible

So that aggregation magic on Grafana side has a reason for it and it protects standard users. Advanced users, who are aware of consequences can override it in query options:

image
image1834×611 48 KB

3

ok i modified my max data points to 60000 and this has resulted in interval changing to 1m (which is what i want). Unfortunately i still have the data aggregating

i view 24 hours of data i get every 1m
i view 7 days of data i get every 7m
i view 30 days i get every 30m
i view 60 days i get every 60m