-
What Grafana version and what operating system are you using?
Grafana v12.3.3 on Docker -
What are you trying to achieve?
I’m using VicoriaMetrics to populate some sensor data from Home Assistant to Grafana. I already build a small climate dashboard for my weather sensors (from ecowitt outside and aqara inside).
Now I want to build a visualization, that shows the monthly rain sum in a bar chart, each month one bar.
I have a monthly rain sensor, that sums the monthly rain value and resets to 0 at each month change. -
How are you trying to achieve it?
I already tried many approaches I found in this community and other websites. I also consulted AI, but nothing worked.
e.g.:- increase(sensor.gw3000a_monthly_rain_piezo_value{} offset -1d) + transformation group by time with format MMM and second transformation calculate total
- sum(increase(sensor.gw3000a_monthly_rain_piezo_value[30d])) + min step 1M
-
What happened?
Shows strange bars, makes absolutely no sense.. -
What did you expect to happen?
I want to have one bar for each month of the current year.
Do you have any idea on how to solve this issue? In my opinion it should be a very basic requirement, isn’t it?
Thanks in advance! 