So I’m monitoring a solar power system with Grafana and InfluxDB, and I have all the values I need, but I’m hoping to look at a graph of values with the query of “for the last 30 days, show the minimum value of each 24-hour period”, but I have no idea if that’s possible or how to go about querying and displaying it. Can anyone help?
There are definitely a range of different ways to go about doing this, but you want to group your query to the 24 hour periods using GROUP BY time(24h) for your query to look something like this (Influx is not my forte, so YMMV, the important thing here is the group by time):
SELECT min(value) FROM ... WHERE $timeFilter GROUP BY time(24h) fill(null);
After that, set Grafana’s time pickers from and to values to now-30d/d and now/d respectively. This will give you the minimum value for each 24 hour period, neatly adjusted to midnight.
Thanks, that’s exactly what I needed.
Hi!
This is exactly what i need too, but i want to compare the power of String1 and String 2 of my solar power system.
The thing is, that i need to calculate the power first from the “mmpt1 voltage” and the “mppt1 Power” (simple formula P=U*I). The Power inverter gives only the summary of both strings
. I realized that stringwise allready with the transform function and it looks great.
Question:
can i use the precalculated values for that? and how?
At the end i need a table where only the max power of String 1 and String2 will be compared, dailywise. And later on in percent difference, total value… and so on but this is later…
Thx Buddies!