toneee
November 8, 2021, 11:17am
1
Grafana Version: Grafana v7.5.7 (Linux)
Im trying to monitor the power usage for a Shelly Plug (All products - Products - Shelly ) It works well and I can get power consumption usage.
I would like to extend this by having a “Usage for the last 24hours” gauge, but unfortunately im a little stuck on how to deal with the data and how to calculate it for 24 hours of usage total.
What I would like to do is have a total calculated from all the readings during the last 24 hours to output 2kwh of power used in total in the last 24 hours.
The output from the shelly plug is in whats and the current consumption at the time of reading.
I hope someone can help as I have been trying multiple different things but none seem to yeild the correct results, unless im using over a megawatt of power a day
Hi @toneee
This is a common question. We will soon release a box-plot plugin that should be able to do this in browser. see this issue:
opened 09:48PM - 12 Nov 15 UTC
type/feature-request
area/panel/common
This may be a bit unconventional for typical time series display, but I think it… could be very valuable.
Right now I emulate this by drawing a time series panel with line graphs with different percentiles. Together they provide information similar to that of a heat map.
<img width="1413" alt="screen shot" src="https://cloud.githubusercontent.com/assets/156867/11131948/0e2953a2-8985-11e5-8c36-75083ed476b7.png">
<img width="233" alt="screen shot" src="https://cloud.githubusercontent.com/assets/156867/11719524/141a63da-9f53-11e5-8b93-e52bb564c04b.png">
And for better insight into data that has daily and weekly patterns, time series overlay help a lot to identify changes in data that always go up and down, but then you can compare it to how it was yesterday, and how it was the same day last week.
<img width="1421" alt="screen shot 2015-11-12 at 21 44 57" src="https://cloud.githubusercontent.com/assets/156867/11132255/cd2e3eba-8986-11e5-8a90-42831687c88c.png">
I think box plots would better serve some of these cases. It does have the obvious draw back of flattening the "time" part of "time series", but one could render multiple ones. E.g. One for last 24 hours, and one for the 24 hours before that, similar to Graphite `summarize(24h)`.
Example box plot from https://codeascraft.com/2015/11/10/q3-2015-site-performance-report/
And here are some resources for doing this with Influx and SQL-type datasources:
1 Like
system
November 8, 2022, 11:17am
3
This topic was automatically closed after 365 days. New replies are no longer allowed.
