I’m not sure if it’s a good place to ask but…
I use Hass.io with RPi3 & Grafana addon. I have separate RPi2 with MQTT broker & MySQL server [I use it for few things and also for HA recorder/history] and I use the MySQL HA recorder’s database as source for Grafana.
made a chart for my daily water usage - whenever my meter is working [water is flowing] an ESP with tasmota installed, publishes the meter’s readings via MQTT. then, I am comparing it with yesterday ones and have “today’s, current usage” as the outcome and the recorder puts this everytime to the database. so I have this in chart’s config:
Time column last_changed
Metric column none
Alias: water daily
Expr: entity_id = 'input_number.water_today'
GROUP BY time(1h, none)
Format as Time series
one that bothers me is the line “Aggregate”. knowing that during the day, every next readout of
input_number.water_today is bigger than last one and it shows current daily usage summed up, I want my chart to use the maximum daily value of this sensor. unfortunately, when I choose “Agregate: MAX” then the chart is empty. “avg” option is mostly useable - the chart looks more logical, but values are not making any sense, because it averages every readout during the day, so it isn’t showing the real consumption.
is there anything I did wrong with above configuration, or “it’s not a bug, it’s a feature”?