Ive got iotawatt sending to an influxdb2 instance running on my synology nas. Ive also got grafana running on the synology and can log into both.
my issue is with the flux language. Yes i know there is documentation… but it reads like (insert foreign language that uses completely different alphabet) to me.
Id love to have a visualization up showing current power being used etc. Eventually what im really after is "Average Power used in a 24 hour period from midnight to midnight. Ill eventually be building an off-grid property and the rental im currently in will be very close in terms of power usage etc. knowing daily power use wil help with battery sizing and solar array sizing.
IMO Flux didn’t work out. I’ve not met anyone that likes it or even that has been able to be proficient with it. You might be better off with influx1 or the soon to be available Influx3.
But as far as your data query needs go, you can get all of what you describe easily and quickly directly from the IoTaWatt using Graph+.h
Yea I think I may try influx1. That’ll be another 6hour rabbit hole trying to find a synology tutorial… deciding what version influx to use etc.
I can easily get a single 24hr period. But getting multiple 24hr periods is what I’m after. As in, the average usage for the period between midnight to midnight during the month of X, or during the three months X- X is …. A min/max of those averages would be helpful too.
I figured grafana might be a bit more customizable when it comes to that. Although even if I could spit them out as CSV and Excel-fu the hell out of it. S.
You should be able to find a 1.8 install tutorial for synolology.
Brett Beeson has some useful posts on continuous queries and configuring IoTaWatt and influx.
Influx and grafana is great for regular reporting but Graph plus on IoTaWatt is good for one offs…
I needed to do some analysis recently for a new electricity tariff (discounted costs for some hours every night offset by slightly higher cost than flat rate the rest of the time)
I used the graph plus function built in to IoTaWatt to pull one month at a time for the past year, downloaded as a csv, and then built up the year in excel, got the data as a pivot table and applied the unit rates.
For my actual usage the new tariff makes sense (assuming no significant changes to the timing of consumption)
As an aside, it was interesting to see the impact of the solar panels on consumption by time of day over the year as a whole.
the only issue i see here is that the resolution of a month of data ends up being at most 1 hour readings. id have to pull 1 week at a time to have 20 minute resolution.
Yea I think I may try influx1. That’ll be another 6hour rabbit hole trying to find a synology tutorial… deciding what version influx to use etc.
One thing: Influx 2.x supports the SQL queries after a little extra configuration, may save you some effort in reinstalling and whatnot. If you have any data already, you would save yourself the headache in migrating it off too.
IMO Flux didn’t work out. I’ve not met anyone that likes it or even that has been able to be proficient with it. You might be better off with influx1 or the soon to be available Influx3.
I used to like it a little bit. If only because it gives a huge amount of flexibility on how to operate on the data. I shudder at the thought of having to rewrite to SQL my queries that calculate specific humidity (when given RH, pressure and other similar parameters); Ignoring the general clunkiness of Flux, it is quite straightforward task there. I hear people in industrial automation invested into Flux for similar reasons.
But yeah, now that it is no longer receiving any improvements of fixes, there is no reason whatsoever to invest any time into it.
