InfluxDB: Grouping data by month

Tags: #<Tag:0x00007f6173a57ce8> #<Tag:0x00007f6173a57c20>


Has anyone solved or figured out a way to group data (influxdb >1.8) by month?
I’m in a process of migrating all persistence from jdbc/mariadb to influxdb but my biggest problem is grouping kWh data monthly (the max value monthly as I reset all kWh counters every month) and representing it in grafana.
Grouping is simple in (my)SQL but I can’t seem to figure this out in Influxdb… I read some about it in this issue but I don’t get the syntax for this nor how to get it working in grafana.

Anyone else figured this out already? :thinking: