- What Grafana version and what operating system are you using?
Grafana 7.5.15 on fedora 35
- What are you trying to achieve?
Display average by hour.
How are you trying to achieve it?
$__timeGroup(ts_mesure,1h) as time,
avg(masse) as value
proprietaire = $proprietaire AND
numero_ruche = $numero_ruche
GROUP BY 1
ORDER BY 1
The time is UTC. When I use the series directly (without average and $__TimeGroup), display is right.
When I use the SQL Query above, data is displayed like UTC was localtime (-2h offset)
What did you expect to happen?
Have the display like raw series (without) offset.
Can you copy/paste the configuration(s) that you are having problems with?
See above query
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
Did you follow any online instructions? If so, what is the URL?
How to put group by time series in the format as by Alias