Energie is a counter it is not possible to calculate! from power! Instant value!. See solution from you exporter value. It is problaly existe natively this metric on your device!
Le mar. 7 janv. 2025, 01:02, Elliott Balsley <elliottbals...@gmail.com> a écrit : > Wow! Both of these methods work perfectly, with Grafana step set to 24h. > It was initially hard for me to wrap my head around this but after thinking > about your examples it makes sense now. Thanks Bryan! > > One more piece that's not working: Even with the time ranges set as you > described (from: now-31d/d, to: now-1d/d), it looks like each measurement > is taken at the current time instead of midnight. Response data looks like > this, at 14:27 local time. > > "Time","Spa" > 2024-12-24 14:27:14,5.15 kWh > 2024-12-25 14:27:14,7.62 kWh > 2024-12-26 14:27:14,7.41 kWh > > Grafana’s time picker says midnight as shown in this screenshot. > > On Monday, January 6, 2025 at 2:01:26 AM UTC-8 Bryan Boreham wrote: > >> Off the top of my head it seems this should be: avg_over_time(watts[24h]) >> * 24 >> If you tried this please say what went wrong. >> >> An alternative would be: sum_over_time(watts[24h:1m]) / 60. >> This uses a subquery to produce a value every 1 minute, adds them all up >> to give a total in Watt-minutes, then divides to get Watt-hours. >> >> Using the counter: increase(watt_hours_total[24h]). >> >> Set the Step in Grafana to 24h to get one point per day. >> Set an "Absolute time range" with From=now-31d/d and To=now-1d/d to get >> 30 days ending midnight yesterday. >> >> Bryan >> >> On Monday, 6 January 2025 at 09:45:21 UTC elliott...@gmail.com wrote: >> >>> Is there a way to do something like GROUP BY in PromQL? My use case is >>> to convert Watts to Watt-Hours. I have a gauge metric measuring >>> instantaneous power consumption every minute. I want to calculate the >>> daily consumption to display in Grafana as a time series with one bar per >>> day over a 30 day period. >>> >>> I found a thread here describing how to do this with Influx, but I can't >>> figure out how to do this in Prometheus. I've tried a bunch of variations >>> of sum_over_time and avg_over_time. >>> https://community.grafana.com/t/calculate-energy-consumsion-manually/45739/2 >>> >>> Alternatively, my energy monitor device also records Watt-hours as a >>> counter metric which resets every day. I'm not sure if that would make >>> this any easier... >>> >> -- > You received this message because you are subscribed to the Google Groups > "Prometheus Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to prometheus-users+unsubscr...@googlegroups.com. > To view this discussion visit > https://groups.google.com/d/msgid/prometheus-users/40ac1755-6e5a-4662-a2df-dc3c51eb8745n%40googlegroups.com > <https://groups.google.com/d/msgid/prometheus-users/40ac1755-6e5a-4662-a2df-dc3c51eb8745n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-users+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/prometheus-users/CAG_EwmMviFQhc8svJxCseg6DNWFrLqMBiZW-bj96BfjSE8Ma1g%40mail.gmail.com.
