How to auto adjust a chart "resolution" as you change the time range (stock market style)

Grafana
1

Hello everyone.

English is not my first language so I hope I can explain it clearly :slight_smile:

I’ve been able to log data into InfluxDB from some sensors using the MQTT telegraf plugin, and using Grafana for visualization.

All is working as expected and I am really happy with the results. However, I am just wondering if is it possible to autosadjust the chart “resolution” panels according to the the time range used in the Grafana UI view, like in the stock markets app:

I will try to explain it better with the following, stock market example:
In the images as much time you go back in time less data is loaded and only the most important logs are shown.

IMG_0633.PNG
IMG_0633.PNG1242×1107 105 KB

IMG_0632.PNG
IMG_0632.PNG1241×1103 117 KB

IMG_0631.PNG
IMG_0631.PNG1242×1119 102 KB

IMG_0630.PNG
IMG_0630.PNG1242×1107 96 KB

IMG_0629.PNG
IMG_0629.PNG1241×1109 94.6 KB

Is it possible to do this in Grafana?

I found a work around adjusting the “GROUP BY - time()”, like seen below.

2
21094×823 75.7 KB

3
31084×763 57.1 KB

But I don’t know how to link the time() to the time range
4

For anyone interested I am running Grafana v7.4 on Linux.

Many thanks in advance!

/Andrés

2

Hi @amalokch,

Grafana provides global variables that will help you achieve just this. I’m not great at influx queries but I think using the $__interval variable in your GROUP BY might help you out. Check out our docs for making an influx query like that:

3

Many thanks Matt,
I didn’t know about this global variables, they seem so powerful in some applications.

For anyone wondering, to make this thing work you may also need to adjust the “Max data points” under the Query options.

1
1812×299 15 KB

Best regards!