Are you aware of an existing node that could be used for visualising time series data?
I would like to analyse local electricity consumption, per day, per week, per month. Depending on the level of resolution, the data should be aggregated and visualised either per hour, per week or per month.
The consumed power is measured by a Carlo Gavazzi power meter. Currently, the cumulative power reading is read over Modbus and stored in a PostgreSQL table once per minute (the cumulative power reading is a stock variable). In addition to stock variables there are flow variables, e.g. temperature, and heat pump compressor modulation (heat pump compressor modulation affects cumulative power consumption)
Stock variables are easy to visualise, because their value at a given time should be know. Flow variables are more tricky to visualise. What should the value for a flow variable be for a given month? As I see it, flow variables would be recorded continuously, and averaged at the time of visualisation, e.g. temperature over a given month.